Viewing 15 posts - 226 through 240 (of 4,820 total)
March 13, 2019 at 2:36 pm
Just to have some fun mixing metaphors...
What if the DBAs at the diner ORDERed BUY the Jerk Chicken? Does it FETCH NEXT itself?
Who CURSORs as a RESULT...
March 13, 2019 at 2:33 pm
As executing such a set of SQL does NOT produce a result set, the setting should probably be NONE.
March 13, 2019 at 2:18 pm
Honestly, a checksum value of only 64 bits for 4,000 bytes just isn't realistic or practical. What is the business case for the checksum value?
March 13, 2019 at 1:46 pm

=SWITCH(Fields!PAL_product.Value...
March 13, 2019 at 1:43 pm
And what, exactly, pray tell, did you then do with that glyph ? Other users will likely want to know...
March 13, 2019 at 1:23 pm
Now that I've looked that up, I'm thinking that your varchar(4000) column might be a pain point. Any row with a couple thousand bytes in it is trouble for hashing...
March 13, 2019 at 1:14 pm
Are you sure that the results of HASHBYTES will never exceed VARBINARY(32) ? I've never used that function, so I have no idea what it does or how it works,...
March 13, 2019 at 1:07 pm
March 13, 2019 at 1:04 pm
You need to anally check to be sure that your method of calculation of CHECKSUM is 100% identical in both environments, and that the data is 100% identical as well. ...
March 13, 2019 at 12:58 pm
March 13, 2019 at 12:53 pm
March 13, 2019 at 10:16 am
This would be a really good reason to create a stored procedure, which can be easily paremeterized, and from within SSRS.
March 13, 2019 at 10:05 am
You're looking for a "file watcher". Even a simple batch file can do that, using VBScript. SQL Agent can be the scheduling methodology.
I'll leave the details of looking up...
March 13, 2019 at 9:43 am
Mu gut says the Switch function requires each "condition" to be either "singular", or that it be enclosed in parentheses. just using AND between the conditions needed is apparently not...
March 13, 2019 at 8:15 am
Viewing 15 posts - 226 through 240 (of 4,820 total)