Topics
Started by
Posts
Last post
Hi I have an datatype nvarchar column containing: Friday Monday Wednesday Tuesday etc.. Can I ORDE…
6 replies
I have a table with the date and data elements in it. I need to produce a resultset in the followin…
1 replies
I have about 50 SPROCS in which the owner needs to be changed. Is there an easy T-SQL way to …
15 replies
Hi, I want to store the result of a "select * for XML" into a table. I managed to do this using bcp…
2 replies
Dear All, How can I get my returned records numbered from a simple SQL statement? Table A: Field 1&…
17 replies
Currently, the following code gets the "last six orders shipped" shipped for one customer. Ho…
2 replies
How to truncate the Transation Log of a given database file by using a T-SQL script https://dbfrien…
8 replies
Hi Gents and Ladies, I am trying to get GoTo written out of the coding standards at work. Everythin…
8 replies
Hi, I have the necessary SQL to create the following unique product ID's: SL000001 SL…
6 replies
Hi, I want to have the contents of the view, means query of the view. Actually i want to read all …
2 replies
I have a table (c2txt) that holds customer notes; there are many notes per customer. I am migrating…
1 replies
Receiving following error when using raiserror with severity level 20-25. RAISERROR ('Exitin…
1 replies
The following currently displays all 365 days and the number of orders placed each day. How can I m…
2 replies
I'm trying to determine how to trap connection errors in T-SQL code. If I run the following c…
11 replies
I have two related tables. Table one is basically a lookup and is the one side of a one to ma…
2 replies
Viewing 15 topics - 11,341 through 11,355 (of 17,082 total)
You must be logged in to create new topics.