Topics
Started by
Posts
Last post
and I can't seem to find the correct syntax. UPDATE UPDTABLE SET updtbl_lat = i.infotbl_lat, updtb…
4 replies
Hi folks, I have a product table that needs 4 columns updating using joins to 2 other tables. Colum…
1 replies
Hi i have the following field in a progress db which contains analysis codes for a given account. …
4 replies
Hello - I've got a lot of experience writing basic queries, but I've not come across the REVERSE(ST…
2 replies
Here is how the table is created... SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDI…
4 replies
Hello all - I would like your input on how to address this problem using T-SQL. I don't expect you…
4 replies
I am trying to generate a one time export to send to a vendor. They are requesting XML and for one…
4 replies
at various times i need to copy the rows to another table but it has minor differences. table1 t1.…
9 replies
I have a table containing 50000 records. The fields are, Phase, KVA, Amt and Group. To begin with…
1 replies
Our users want a Dump of the SQL Data which could come by running Query and Stored Procedure every …
3 replies
Got the insert part going just trying to figure out how avoid duplicate error. i have figured out h…
4 replies
Declare @SVPID int Set @SVPID = 0 Select SummaryTitle = Case When @SVPID = 0 Then 'All SVPs' Else D…
2 replies
Hi, I have a character srting that has leading 0's,How can I get rif of those leading 0's from this…
5 replies
Hi, I want to move file from c:\test1\test1.txt to c:\test2\test1.txt using FilesystemObject. I am …
14 replies
Hi, I have one query.i face one issue almost every day. We have lot of scheduled jobs configured ,s…
2 replies
Viewing 15 topics - 511 through 525 (of 12,234 total)
You must be logged in to create new topics.