Viewing 15 posts - 2,266 through 2,280 (of 2,894 total)
Ninja's_RGR'us (8/10/2011)
Eugene Elutin (8/10/2011)
Ninja's_RGR'us (8/10/2011)
... but I wouldn't spend 1 year refactoring an app without more proof of the benefit...
seriously, as a contractor, in a such economy hardtime, I definitely...
August 10, 2011 at 12:04 pm
CELKO (8/10/2011)
August 10, 2011 at 12:01 pm
I knew from start that you would get JC response on this one:-D
Actually, I wanted to post similar reply, just in shorter words...
It's quite unusual to ask SQL to return...
August 10, 2011 at 11:48 am
thompson 44810 (8/10/2011)
...Our quandary is can a temp variable be created and can that be used to pull data from?
We are trying to do this without creating a separate table.
...
AND
thompson...
August 10, 2011 at 11:29 am
CELKO (8/10/2011)
...I have written tens of thousands of words on this in my books
...
Writing thousands words has nothing to do with being right. There are a lot of fat books...
August 10, 2011 at 11:02 am
thompson 44810 (8/10/2011)
...So my question is can a temp variable or temp table be used to pull data from and if so how.
Ough, that is what you are asking, it...
August 10, 2011 at 9:45 am
I bet that you have misuderstood the client requirements.
Or misrepresented them in your post:
Most likely they want standard fixed-length extract, which means that every field will be of the...
August 10, 2011 at 9:38 am
Yeah, this post looks like the old puzzle to me:
"There were two crocodiles flying. One to the south but another one was of blue colour. Question: How many chairs in...
August 10, 2011 at 9:25 am
If it's going to be used for reporting, I would consider to place this one into stored procedure where you could use temp tables for intermidiate values/sets.
Your query doesn't look...
August 10, 2011 at 9:13 am
Ninja's_RGR'us (8/10/2011)
... but I wouldn't spend 1 year refactoring an app without more proof of the benefit...
seriously, as a contractor, in a such economy hardtime, I definitely would 😀
And if...
August 10, 2011 at 8:54 am
In our nanoworld, nanoseconds are precious 😀
Couple relevant links:
http://technet.microsoft.com/en-gb/library/cc966420.aspx
and
http://www.sqlservercentral.com/articles/Administration/procedurecache/591/
In the last one you will also find why naming stored procedures with sp_ prefix is not good idea...
August 10, 2011 at 8:25 am
Jayanth_Kurup (8/10/2011)
Eugene Elutin (8/10/2011)
Jayanth_Kurup (8/10/2011)
...I read somewhere if the schema name is not provided usually it searches all sys and dbo schemas before looking for any user defined schema objects.
It's...
August 10, 2011 at 6:36 am
Jayanth_Kurup (8/10/2011)
...I read somewhere if the schema name is not provided usually it searches all sys and dbo schemas before looking for any user defined schema objects.
It's not exactly right:...
August 10, 2011 at 3:52 am
maruthipuligandla (8/9/2011)
the reason why i used uniqueidentifiers was, when we need to insert one unique value into 2 tables at the same time we can make sure the same values...
August 10, 2011 at 3:16 am
Next time, please provide ddl and sample data insert script as part of your question (see the link at the bottom of my signature how to do so)
SQL UNPIVOT has...
August 9, 2011 at 9:27 am
Viewing 15 posts - 2,266 through 2,280 (of 2,894 total)