Viewing 15 posts - 13,636 through 13,650 (of 15,381 total)
Is this a one time thing or a repeatable process? I am guessing it is something you need to repeat.
October 21, 2011 at 12:59 pm
Man I dislike uniqueidentifier. It is nothing but a pita. Can you store your data in a varchar(36) instead of a uniqueidentifier column?
October 21, 2011 at 12:52 pm
Wow it is pretty hard to name your database. 😛 Nobody on this side of the screen knows your process, projects etc. Maybe PosExt or something.
October 21, 2011 at 11:54 am
You can't do this in a function. Dynamic sql is not allowed in a function.
http://blog.sqlauthority.com/2007/05/29/sql-server-user-defined-functions-udf-limitations/%5B/url%5D
Also to use a table value parameter you have to define the table as a User-Defined...
October 21, 2011 at 10:13 am
It should be possible to do something like that. If you want help you are going to need to provide a LOT more information. Check out the first link in...
October 21, 2011 at 10:06 am
Try adding the state code to your join to CRD1
October 21, 2011 at 10:00 am
Good question and with 40% incorrect answers with over 500 responses it seems a back to basics topic that lots of people don't know.
October 21, 2011 at 7:28 am
Check out the link from MyDogJessie or this link from BOL. http://msdn.microsoft.com/en-us/library/ms189799.aspx
October 20, 2011 at 3:43 pm
Why without triggers? That is what they are good at. You pretty much have two choices, triggers or CDC (Change Data Capture).
October 20, 2011 at 3:29 pm
This has to be one of the most irritating things about sql. Why can't the error contain the column name? The engine obviously knows which column. GGGGRRRRRR!!!!!!!!! There is ...
October 20, 2011 at 3:18 pm
ByronOne (10/20/2011)
I need a little help with the Switch function.
I have a table report in SSRS 2008 which has the following three columns of data:
Agreement Accepted / Date Agreed...
October 20, 2011 at 2:13 pm
Take a look at the splitter function in my signature from Jeff Moden. The DelimitedSplit8Kfunction can do exactly that with no looping.
For example if you want element 3 from 1,2,3,4,5...
October 20, 2011 at 10:09 am
Phil Parkin (10/20/2011)
Sean Lange (10/20/2011)
October 20, 2011 at 9:05 am
Viewing 15 posts - 13,636 through 13,650 (of 15,381 total)