Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
 Posted - 2012-01-26 : 09:39:09
|
arkiboys post history:quote:
temp table in dynamic sql rename field drop column check existance of table nvarchar(max) dynamic pivot dynamic fields select field names of global table .....
this is not going to end well! I've tried to suggest that he/she tells up what they are trying to do but with no success.We are enabling something that I think is going to be a nightmare.arkiboys: are you *sure* you don't want to discuss what you are trying to do? We could help in morebetter ways than just giving you enough rope to hang yourself....Anyway -- this is my last attempt. I hope you take it up.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-01-26 : 09:45:02
|
[like]
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-01-26 : 10:07:11
|
[Like] 2
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2012-01-26 : 13:39:18
|
As a last ditch attempt, I say we invite Celko back to have a chat with him...  http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-26 : 14:30:49
|
| Yes, it does, but often it's money with unnecessary headaches. I'd rather a less chaotic environment, easier to get under control, less surprises hiding in the code.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
DANGER WILL ROBINSON......