Viewing 15 posts - 8,791 through 8,805 (of 19,560 total)
msoutherland (9/7/2011)
I need to pull all of the values from the table where the value of the field is...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 7, 2011 at 12:53 pm
Stefan Krzywicki (9/7/2011)
LutzM (9/7/2011)
SQLRNNR (9/7/2011)
Stefan Krzywicki (9/7/2011)
SQLRNNR (9/7/2011)
SQLkiwi (9/7/2011)
Stefan Krzywicki (9/7/2011)
OK, who had 9/7/2011 in the end of the world pool?Hmm. Where's the incentive to win?
You get a billboard...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 7, 2011 at 12:34 pm
It appears that your query does not match your parameter.
You are comparing a field "name" to the value of your parameter. Is that correct?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 7, 2011 at 12:31 pm
Once the param is populated, what do you do with it next? Are you pulling info from another dataset? Is that info populated via adhoc query or stored...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 7, 2011 at 12:13 pm
msoutherland (9/7/2011)
I've tried quotes & no quotes around the values. I've tried the following for the "No" values:
CANCELLED, INACTIVE
"CANCELLED", "INACTIVE"
"CANCELLED, INACTIVE"
"CANCELLED" & ", " &...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 7, 2011 at 11:58 am
Also, if you created those values and labels manually - did you use quotes around the values?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 7, 2011 at 11:36 am
how are those values for the parameter being populated? Are they from a dataset or did you manually create the values?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 7, 2011 at 11:35 am
jcrawf02 (9/7/2011)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 7, 2011 at 11:33 am
piet.kouwer (9/7/2011)
notoriousdba (9/7/2011)
Piet,Maybe you haven't been in this game long enough to know who Joe Celko is. Not for nothing, but if he talks, you should listen.
I will listen, but...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 7, 2011 at 11:31 am
Stefan Krzywicki (9/7/2011)
SQLRNNR (9/7/2011)
SQLkiwi (9/7/2011)
Stefan Krzywicki (9/7/2011)
OK, who had 9/7/2011 in the end of the world pool?Hmm. Where's the incentive to win?
You get a billboard posted by a highway...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 7, 2011 at 11:30 am
SQLkiwi (9/7/2011)
Stefan Krzywicki (9/7/2011)
OK, who had 9/7/2011 in the end of the world pool?Hmm. Where's the incentive to win?
You get a billboard posted by a highway in the US,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 7, 2011 at 11:13 am
Gianluca Sartori (9/7/2011)
SQLRNNR (9/7/2011)
Gianluca Sartori (9/7/2011)
Uh, I guess the "spaghetti dba" should definitely buy this one, but I don't know how I would look like with it.😛
ermmm that one is...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 7, 2011 at 10:19 am
Gianluca Sartori (9/7/2011)
Uh, I guess the "spaghetti dba" should definitely buy this one, but I don't know how I would look like with it.😛
ermmm that one is for the Junior...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 7, 2011 at 10:08 am
mtillman-921105 (9/7/2011)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 7, 2011 at 10:00 am
harmoniously
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 7, 2011 at 8:59 am
Viewing 15 posts - 8,791 through 8,805 (of 19,560 total)