Topics
Started by
Posts
Last post
My requirement is to have an automated way of figuring out the settings of configuration properties…
3 replies
How would i make the following update statements into a single statement without missing any criter…
1 replies
I have several stored procedures that are ran monthly. At the moment we manually copy the output …
3 replies
Here is my sample data: declare @t1 table (loadId int, dataId int, Code varchar(50), imageName var…
9 replies
Can anyone help me on following string manipulation? Basically i want to trucate the digits before …
4 replies
I'd like to write a procedure that will take the data from an 'Import' table with Select (Id, Name,…
8 replies
Hi, I have a requirement where i need to update a SQL table myTable from a text file myText.txt. Re…
16 replies
I have been searching and finding nothing. Is there a simple syntax that I can use to achieve what …
8 replies
We have a number column (Duration) that stores data in seconds. How can we return the data in hours…
3 replies
Hi all, I have a requirement to update a table that will use the existing dates and derive two new …
2 replies
I am trying to connect to ODBC teradata DB from SQL SERVER import export tool.. when clicked in and…
2 replies
when using: set ansi_nulls on what is the best way to filter using parameters and allow for nulls: …
1 replies
update TOP (10000) dbo.Adm_History2 set fixpaid = case when rc.dpaid=1 then 0 else 1 end from dbo.A…
10 replies
Hi guys, Refer to the table structure as stated below: create table #prod (pid int, name varchar(10…
5 replies
I'm stuck trying to find what is wrong with my code. It works for some databases and blow up for ot…
12 replies
Viewing 15 topics - 3,181 through 3,195 (of 12,234 total)
You must be logged in to create new topics.