Viewing 14 posts - 16 through 29 (of 29 total)
Unfortunately there would be hundreds of values.
I tried to reference to rstADO as a regular recordset (not a string), as it was defined earlier in the code. Didn't...
February 12, 2019 at 2:44 pm
January 3, 2018 at 12:16 pm
Ok *success*, I think that I figured out the use of table UDF...
SELECT I.StockCode, I.Description, I.AlternateKey1 AS Family,
I.LeadTime, I.Ebq, W.Warehouse, U.RET AS...
October 13, 2017 at 6:10 am
EDIT: Creation didn't work. On an hunch, removed WITH SCHEMABINDING and the creation of the function passed Is it essential?
EDIT...
October 12, 2017 at 2:46 pm
I guess that I did something that should be a no-no... lol! I remember having seen this RETURN TABLE instead of a variable in a SQLCENTRAL article a few...
October 12, 2017 at 1:07 pm
October 12, 2017 at 9:01 am
Awesome (and learning)
Now getting the best of both worlds, I tried to alter the last tvf function (that was working) with other examples I found. Basically a...
June 21, 2017 at 9:18 am
I read stuff about CROSS_APPLY that might be relevant (is it?)
June 20, 2017 at 1:19 pm
Thom A - Tuesday, June 20, 2017 10:06 AMYou're using your CASE expression incorrectly.
So I thought. Thank you!
Instead of doing this...
June 20, 2017 at 11:18 am
June 16, 2017 at 7:26 am
SELECT InvMaster.StockCode, InvMaster.Description, AdmFormData.KeyField, AdmFormData.FieldName
FROM InvMaster LEFT OUTER JOIN
AdmFormData ON InvMaster.StockCode = AdmFormData.KeyField
WHERE (AdmFormData.FieldName = 'NAFTA') or (AdmFormData.FieldName IS NULL)
EDIT:...
June 15, 2017 at 7:36 pm
Well it is quite possible that we complicate things, made to be easier.:-)
IT provided me that user, attached to all users login (authenticated windows ). I know...
June 20, 2016 at 8:56 am
That query generates the statement, copy-paste once you've checked it, then run it.
Beautiful! Txs a lot.
June 20, 2016 at 7:40 am
db_datareader was already added manually but it doesn't seem to work.
SELECT 'GRANT SELECT ON [' + TABLE_SCHEMA + '].[' + TABLE_NAME + '] TO [MyUser];'
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE';
This...
June 20, 2016 at 7:32 am
Viewing 14 posts - 16 through 29 (of 29 total)