Viewing 15 posts - 5,881 through 5,895 (of 7,168 total)
whole (6/24/2011)
so,...
June 24, 2011 at 4:28 pm
Are all OrderHeader_ID in the table convertable to INT?
Why is it not an INT?
Preferred way: alter the table so the data types match.
Workaround: add a computed column that...
June 24, 2011 at 4:10 pm
Jeff Moden (6/24/2011)
opc.three (6/24/2011)
Be careful with table variables. They always optimize with an assumed rowcount of 1 so can produce very bad execution plans...even with small actual rowcounts.
A statement level...
June 24, 2011 at 3:22 pm
Is this synchronous or asynchronous mirroring?
June 24, 2011 at 2:02 pm
denis.p (6/24/2011)
There are two tables - Lines and Heads, and there are two triggers - one for each table.
Both are defined as "after-"...
June 24, 2011 at 1:54 pm
S_Kumar_S (6/24/2011)
...But still want to be sure that my procs and functions dont break when we change the level.
Wow, I hope you're not asking for people that have no idea...
June 24, 2011 at 1:34 pm
Tough spot. It sounds like you know enough T-SQL to get it going, but yeah, 2,000+ lines of procedural T-SQL code is what you get when you do stuff like...
June 24, 2011 at 1:07 pm
denis.p (6/22/2011)
June 24, 2011 at 12:57 pm
Eric M Russell (6/24/2011)
Jeff Moden (6/24/2011)
June 24, 2011 at 11:22 am
Jeff Moden (6/24/2011)
June 24, 2011 at 11:18 am
Not sure if I understand cmopletely because you have three names floating around: DBNEW, DBSQL and DBOLD\SQL. How I read the post is that you want requests that were going...
June 24, 2011 at 11:04 am
This one looks like homework. I agree with Sean that things like this should be left to the presentation layer. That said, if this is homework or your hands are...
June 24, 2011 at 10:40 am
jarid.lawson (6/23/2011)
CELKO (6/22/2011)
Why do you want to do this in SQL? It was never meant for writing parsers. And you got some data element names wrong.
I don't get a...
June 24, 2011 at 10:19 am
Jeff Moden (6/24/2011)
Craig Farrell (6/23/2011)
This conversation resparked a curiousity on my part.
When I run that code as a single unit, it keeps returning the following error...
There is already an object...
June 24, 2011 at 9:24 am
You're very welcome 🙂
June 24, 2011 at 7:53 am
Viewing 15 posts - 5,881 through 5,895 (of 7,168 total)