Topics
Started by
Posts
Last post
Hey all, First time poster here. I'm writing a trigger using the xp_sendmail XSP to send ema…
3 replies
I need to run an update on the data below. I need to update the profile_id's with '0' to the same p…
1 replies
I am having trouble with the following query: insert into _SMDBA_._CONFIG_ (CFG_CCDT01…
1 replies
I am loading medical claims data from a text file into a new SQL Server database and new table.&nbs…
4 replies
Hi, I’m using a database for read purposes only. The data comes in as a huge CSV feed, is imported …
4 replies
Hai all, I have two tables t1 and t2, I am trying to UNION ALL betn them and Order by time st…
1 replies
I am trying to learn how to use a table variable instead of a temp table, could some one explain ho…
2 replies
How can I find out if I am missing a date? In the following example, I am missing July 8th. FIrst r…
2 replies
Hi All, I have a table T1 with 2 columns. T1 EmpId &…
3 replies
I'm trying to calculate a value and use that calculated value in a CASE statement without repeating…
7 replies
I have the model# like 'r001','r002','r003','c001','c002','c003''c004' i want to write a storeproce…
4 replies
What is the best way to convert a float to a string value with comma separated thousands and no dec…
5 replies
So I have Table1, 2 columns K1 varchar(10), K2 BIT(defauilt 0). When I insert a record, I wish…
5 replies
I need to compare two dates in the stored procedure: one is datetime that gets value from the syste…
5 replies
Hi : I am trying to retrive the number of day in a quarter based on date using T-SQL or DTS. For ex…
6 replies
Viewing 15 topics - 12,541 through 12,555 (of 17,082 total)
You must be logged in to create new topics.