Topics
Started by
Posts
Last post
I have a query I am trying to write and this is my first attempt at something like this. I need to …
24 replies
Hi, I want to send the results of a query as the message of an SMTP mail i.e. @message = S…
9 replies
Hi, I am using CTE in a Procedure. While executing the Procedure the CTE should returns null value…
5 replies
I have to columns that performs sums. However I want the specific data type to be decimal with two…
3 replies
I need to write some SQL to determine when a record in a table (UsedVehicles) was last updated. I …
8 replies
How can I do this using t-sql? I have two tables, t1 and t2, t1: c1 c2 c3 …
2 replies
Hi, I have a field that contains the number of days between a dated field and today (utilizing date…
5 replies
The field data type is INT. I want to display it always as "01","02","03" format. What is the best …
11 replies
I have 2 tables . Dept and Names . Now I need to grant access to 1 person in Names table on 1 depar…
1 replies
I am trying to remove several lookups in an SSIS package by moving these into 1 stored proc to redu…
3 replies
I have to write a stored procedure that does a numeber of things but the first issue I cant figure …
2 replies
Hi. I have been asked to insert all Products from table Products into ProductProductCategories wher…
4 replies
Dear Friend, My situation as follows i have two databases , each databases are in different locati…
1 replies
I'm very new to Pivot Tables in SQL 2005, after working with the TSQL for a while, I final got scri…
7 replies
hi guys, what is the best way to delete two million rows from a table that the date created is afte…
25 replies
Viewing 15 topics - 8,281 through 8,295 (of 12,230 total)
You must be logged in to create new topics.