Topics
Started by
Posts
Last post
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
If one (or more) field(s) listed in Partition By have nulls - how ROW_NUMBER () handles these rec…
20 replies
Hello, everyone, I'm pretty sure I'm missing something simple here, but its not easy to search anyw…
14 replies
Hi, I got a table which has contents like TbaleA Col 100 100A1 1000 1000B1 1000C1 200D1 Now i want …
3 replies
hi i have stored procedure which takes parameter as datetime datatype. i need to cast that it beh…
4 replies
Viewing 15 topics - 7,351 through 7,365 (of 10,647 total)
You must be logged in to create new topics.