Viewing 15 posts - 331 through 345 (of 542 total)
Ninja's_RGR'us (10/13/2011)
Check up that series, might give you great pointers :
This is getting out of hand now, I am unable to find the particular piece of code in the...
October 14, 2011 at 9:14 am
Ninja's_RGR'us (10/13/2011)
Start the trace, run the report (make sure to hit refresh to get new dataset).Then copy and paste the command sent here so we can see that for starters.
Is...
October 13, 2011 at 7:40 am
Ninja's_RGR'us (10/12/2011)
You point the trace to whatever sql server the report gets the data...
October 13, 2011 at 2:06 am
Ninja's_RGR'us (10/12/2011)
Open profiler, connect...
October 12, 2011 at 9:43 am
Ivanna Noh (10/4/2011)
October 12, 2011 at 4:23 am
Ivanna Noh (10/4/2011)
October 6, 2011 at 6:05 am
Sean Lange (10/5/2011)
pwalter83 (10/5/2011)
I have a requirement to update the values in a table thru SSIS, however, there is a primary key restriction. The table has a combination of 3...
October 6, 2011 at 1:59 am
tfifield (9/29/2011)
You can fire up...
September 30, 2011 at 2:10 am
tfifield (9/28/2011)
pwalter83 (9/27/2011)
Ninja's_RGR'us (9/26/2011)
pwalter83 (9/26/2011)
Ninja's_RGR'us (9/23/2011)
What's the value you have in that variable?@Commoditylike
The value comes from a column called Commodity.
I meant when you run the query and it fails to...
September 29, 2011 at 3:39 am
Ninja's_RGR'us (9/26/2011)
pwalter83 (9/26/2011)
Ninja's_RGR'us (9/23/2011)
What's the value you have in that variable?@Commoditylike
The value comes from a column called Commodity.
I meant when you run the query and it fails to return anything.
Oh...
September 27, 2011 at 2:46 am
Ninja's_RGR'us (9/23/2011)
What's the value you have in that variable?@Commoditylike
The value comes from a column called Commodity.
September 26, 2011 at 2:08 am
Ninja's_RGR'us (9/23/2011)
pwalter83 (9/23/2011)
Ninja's_RGR'us (9/23/2011)
and (Commodity like '%' + @Commoditylike + '%') or (@Commoditylike Is NULL)
I tried this one before including some other permutations and combinations but this hard shell doesnt...
September 23, 2011 at 7:58 am
Ninja's_RGR'us (9/23/2011)
and (Commodity like '%' + @Commoditylike + '%') or (@Commoditylike Is NULL)
I tried this one before including some other permutations and combinations but this hard shell doesnt crack !!!!!!!!!!!
September 23, 2011 at 7:50 am
thundersplash845 (9/23/2011)
try this..where (Commodity like '%' + @Commoditylike + '%') or (Commodity Is NULL)
I have tried this but it still does' nt work. If I remove this parameter from...
September 23, 2011 at 7:37 am
Ninja's_RGR'us (9/23/2011)
Hmm... can you post the full statement? I think I know what you're having problems with.Reading this is not a bad idea (just to know it exists)
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries
I...
September 23, 2011 at 7:35 am
Viewing 15 posts - 331 through 345 (of 542 total)