Viewing 15 posts - 26,476 through 26,490 (of 59,102 total)
asifejaz (7/4/2013)
This will solve it but urpose is not achieved. i am using a cursor to fetch records with combination of primary...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2013 at 5:39 pm
sqldbaonly (7/5/2013)
hi,Tell different tricks and fusible ways ?
For T-SQL...
Tally Table, Pseudo-Cursors, "Set-based" thinking, SARGable queries, "Divide'n'Conquer" techniques, Windowing Functions, Cascading CTEs and Cross Apply's, deep understanding of B-Tree indexing,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2013 at 5:35 pm
sharonsql2013 (7/5/2013)
I declared the primary key as identity int.
Now everytime a value(code) is selected from the grid , I want a corresponding character to be concatenated to the primary...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2013 at 4:52 pm
Just to add to what Laurie posted...
The dbo.sysjobhistory system table in MSDB does keep track of duration and both the job and the level. It certainly won't give you...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2013 at 4:32 pm
niladri.primalink (7/4/2013)
However your input has helped me to solve it.
Two way street here... please post the code you ended up with so someone else can learn from it. Thanks.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2013 at 1:29 pm
dwain.c (7/4/2013)
What in Buddha's name is a "lac day?"
"lac" is 100,000 in the OP's language.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2013 at 1:26 pm
richard.austin (7/4/2013)
I have a query that takes 2 seconds to compile and run (first time round) when the server is restarted. When the server has been up and running...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2013 at 5:26 pm
And now we know why test data is essential for such "general" questions. 😛
Just to add my 2 cents, you can combine the Year and Month comparison by doing the...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2013 at 5:21 pm
I don't have your tables or data so I can't really tell what's going on especially since I can't gen the actual execution plan. I did do a simple...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2013 at 4:48 pm
Banana-823045 (7/4/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2013 at 3:30 pm
Davebhoy (7/4/2013)
I'm a novice a at SQL so hopefully this is an easy answer for someone.
I have a basic view which queries two tables in separate databases with one...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2013 at 11:44 am
To add to what Steven has already posted, there's really no need to redevelop the wheel. Buy a "CASS Certification" program that will do this for you. It'll...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2013 at 11:23 am
sqlpanther (7/3/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2013 at 11:10 am
niladri.primalink (7/4/2013)
In a table (sale.person) I have more than 9 lacs row. I have only three columns. I need to add a column by Orderdate (which I have done...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2013 at 10:55 am
bleroy (7/4/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2013 at 10:29 am
Viewing 15 posts - 26,476 through 26,490 (of 59,102 total)