Forum Replies Created
Viewing 15 posts - 3,586 through 3,600 (of 5,356 total)
-
RE: execsql vs direct statement
Take a look at BOL for sp_executeSQL -> Using sp_executeSQL.
This is somehow expected behaviour.
What about a third approach?
Putting your statement into a sproc and call this from ADO?
Frank
-
RE: cross tabs quesry?
quote:
Agree, mostly, but not always desirable. I do my cross tabs on the client. Have done some in tsql but mostly for... -
RE: cross tabs quesry?
quote:
When somebody considers himself/herself to be "enough of an expert", that suggests arrogance.I agree
Correction: After...
-
RE: cross tabs quesry?
This is the first time I hang around on the forum in the evening.
Hey, I'm really looking forward to my notebook I get next week and the company sponsored DSL...
-
RE: cross tabs quesry?
quote:
I like Schiller, but I think Dilbert (Scott Adams) put it even better: "Argue with an idiot and he will drag you... -
RE: cross tabs quesry?
quote:
I cringe to think of all the dancing that will be forced upon Yukon with the CLR extensions.October 31, 2003 at 3:01 pm
-
RE: Subscription on articles
Could it be you guys get awake when weekend is near
Hey, after all Snitz is #1 ASP based forum solution, or not?
Frank
-
RE: cross tabs quesry?
quote:
Looking beyond this example and considering a typical crosstab query...Are you saying that the grouping and aggregation done in a typical crosstab...
-
RE: cross tabs quesry?
quote:
She decided I wasn't enough of an expert and reposted her question to another SQL Server list! -
RE: cross tabs quesry?
umh..got disturbed by the little mini-me. Needs to be fed. Now I have some two hours time left.
To finish my post: most front-end languages have very sophisticated functionalities for this....
-
RE: cross tabs quesry?
Good evening David,
quote:
Sure interesting the number of times this type of problem crops up. For problems like this cursors seem the best... -
RE: cross tabs quesry?
quote:
That method has a real name (Characteristic Functions), has been around for about a decade and has... -
RE: dynamically FROM clause
Oops, thanks!
I should included some lately threads http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=17674
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=17637
Frank
-
RE: Query a Sql Server LOG (LDF) File
Things are getting clearer now.
But when you know the table has been updated, why do you want to know which column(s) have been updated. Figuring that out, including all implication...
That method has a real name (Characteristic Functions), has been around for about a decade and has...
Viewing 15 posts - 3,586 through 3,600 (of 5,356 total)