Topics
Started by
Posts
Last post
HI, I am trying to write a script to dynamically generate a CREATE VIEW Statement that is a union o…
3 replies
SQL 2005 I have a simple TSQL statement to extract a subset or rows from a table with 434 million r…
22 replies
ALTER TABLE dbo.myTable ADD CONSTRAINT DF_myTable_Q DEFAULT(0) FOR Quota If I execute the above cod…
26 replies
Am using cursor to accomplish the below result. It takes huge time(around 5 million records ) to co…
14 replies
I want to trim a given string so that ppl could see them without long empty spaces inbetween words.…
21 replies
check if any records match if match ---rec match/not match when used full outer join both tables no…
4 replies
I am new to SQL and I have 2 issues I am seeking help. (1) How do you import CSV file using query…
2 replies
How to create a format file for below records "AB1234" "12345" 30 no 40 "AB1235" "12346" 40 no 50 "…
1 replies
Hi, I need to write a SQL query which has to allow the user to enter the year during runtime. Can…
18 replies
Hi there I have the following Code SELECT dbo.DW_SALESINVOICES_F.Reference AS [Sih.Reference], …
25 replies
Hi. I'm looking for any suggestions on how to accomplish the following: I’ve got a table with recei…
4 replies
MainTable ( ID , Tab1ID,Tab2ID) Table1(Tab1ID,Tab1Description) Table2(Tab2ID,Tab2Description) CREAT…
3 replies
This is a followup to a question I had last week about updating a text column. Here I want to repla…
4 replies
Hello, Thare are 2 databases one is in sql 2005 other is in sql server 2000 How to implement a sync…
2 replies
Hi to all , I have this trigger , when I want to delete a record from the table im getting the belo…
8 replies
Viewing 15 topics - 5,446 through 5,460 (of 12,234 total)
You must be logged in to create new topics.