Forum Replies Created
Viewing 15 posts - 226 through 240 (of 4,820 total)
-
RE: Today's Random Word!
Ray K - Wednesday, March 13, 2019 2:12 PMSteve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)RE: The SQL Joke Thread
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...Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)RE: Passing datatime , int variables into a table through execute sql task in SSIS
As executing such a set of SQL does NOT produce a result set, the setting should probably be NONE.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)RE: Difference in checksum calculations.
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?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)RE: Creating a custom field and creating an expression to populate it
Shabbaranks - Friday, March 1, 2019 9:22 AMHi,
Any reason why my SWITCH statement isn't returning any values?
=SWITCH(Fields!PAL_product.Value...Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)RE: Font Awesome in Reports
And what, exactly, pray tell, did you then do with that glyph ? Other users will likely want to know...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)RE: Difference in checksum calculations.
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)RE: Difference in checksum calculations.
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,...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)RE: trimming SSNs
Matt Miller (4) - Wednesday, March 13, 2019 1:00 PMSteve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)RE: Difference in checksum calculations.
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. ...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)RE: Top most manager name with out CTE
manesh561 - Wednesday, March 13, 2019 5:47 AMSteve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)RE: trimming SSNs
pietlinden - Wednesday, March 13, 2019 9:58 AMSteve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)RE: Filtering by date crashes report\query
This would be a really good reason to create a stored procedure, which can be easily paremeterized, and from within SSRS.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)RE: check if a file exists and run
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...Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)RE: SSRS Expression Error
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)Viewing 15 posts - 226 through 240 (of 4,820 total)
