Topics
Started by
Posts
Last post
We have a large table(60 million rows),which receives lots of inserts per second.I notices that for…
14 replies
hi! a little help here please. i have here 3 tables, the cluster table, field table and a variety …
7 replies
select c.customerid,c.firstname,c.lastname,o.totalprice from Test_Customer1 c inner join (select cu…
1 replies
Hi Guys I am looking to sharpen my T-SQL skills I've been eyeing the T-SQL Fundamentals book by Itz…
4 replies
Hi i have a query whihc looks for a value in a table like select name from tableA where name='XYZ' …
12 replies
I have a query regarding Query optimization.[font="Arial"][/font] Which one of the following is pre…
12 replies
I have a list of cummulative percents. Depending on the year, this list can be 500,000 to a million…
4 replies
Hi I got two table tb1 and tb2 tb1 has two columns part (Identity column) and value tb2 has two co…
1 replies
1) How do you return an ERRORLEVEL code of say 0,1 or 2 to a bat file or the cmd o/s, depending the…
15 replies
hi how can i use date conversation function to convert date in 'CCYY-MM-DDThh:mm:dd' format in sql
19 replies
Hello, We are having a lot of backup server issues. I think a lot of backups are scheduled at the …
7 replies
Main query: select JB.ID1, JB.ID2, JB.stat,JB.item,JR.oper_num, JR.complete, JR.qty_complete from T…
17 replies
Hello All, Given this procedure: CREATE PROCEDURE uspSub @ID INT AS SELECT getdate() How can I call…
5 replies
What options do I need to consider to make this pk creation go as fast as possible? ALTER TABLE Ce…
3 replies
Hi Experts, I am a newbie to SQL Server 2008. And I am trying to use the merge statement which give…
5 replies
Viewing 15 topics - 7,336 through 7,350 (of 10,635 total)
You must be logged in to create new topics.