Topics
Started by
Posts
Last post
Using TSQL, how would I get a count of active records, grouped by month where I have a OpenOn date …
6 replies
How to void displaying ''1900-01-01 00:00:00.000" if datetime data is null?
7 replies
Hello, Can you tell me how to display different values of rows in one single row. Suppose my output…
1 replies
I have two tables. One is Master table and other one is sync data table. When the data uploaded f…
8 replies
Hi all, I am trying to write a trigger on a table to update a date/time column with the sysdatetime…
5 replies
I have the following two queries: INSERT INTO 6_1_Execupay ( [File #], [hours 3 code], [hours 3 amo…
3 replies
I'm about to build a function that returns a stock code that was superceded by another. However Cha…
6 replies
Hi, I had found lot of script for Index Rebuild script in Google, But all are executed automaticall…
1 replies
Hello, I've got a relatively long-winded query containing a number of subqueries and I'm asking for…
9 replies
Anyone seen this?? Thanks Stephen
1 replies
Hi, I am using the below code to create a text file from SQL server 2005. DECLARE @vCmd VARCHAR(MAX…
4 replies
hallo i'm having troubles in all of the sql server 2000 STD italian. yesterday everything worked fi…
5 replies
I have a database the uses product trees. A product tree is a Bill of Materials (BOM). A BOM is u…
18 replies
I have a s/p along the lines of: select * from mytable where id in(@ids) id is an int and @ids is d…
2 replies
I have ASCII text files that have no header and are not CSV. I used BCP to create import masks that…
1 replies
Viewing 15 topics - 586 through 600 (of 17,082 total)
You must be logged in to create new topics.