T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• convert left(datetime ,11) and order by

  i have a table of datetime vals. I need to get only the distinct dates (don't care about times) &#…

  snomadj

  7 replies

  16 years ago

  By: snomadj

• Need to convert column display INT to DATETIME

  [font="Courier New"]This script below renders job name -AND- average duration for each job. (The A…

  Express12

  3 replies

  16 years ago

  By: Old McDonald

• Help on Insert Trigger

  Hi All I have created a table as shown below Create table #temp (ID int,Levelid int, v…

  CrazyMan

  3 replies

  16 years ago

  By: Adi Cohn-120898

• Get Procedure call with Parameters when called from RPC (Reporting Services.)

  Hi I am trying to capture the Stored Procedure call executed by a report. When executing my TestPr…

  Jules Bonnot

  4 replies

  16 years ago

  By: Jules Bonnot

• Call stored proc from stored proc

  I know this should probably be easy but I've tried several syntaxes and none of them work. I basica…

  Noc234234

  6 replies

  16 years ago

  By: Gail Shaw

• merge errors

  Essentially want to insert/update rows from tasks table to tasksimport. MERGE TASKSIMPORT as Targ…

  Sailor

  1 replies

  16 years ago

  By: dsdeming

• Script won't run when placed into a Job step

  I have a script, from a vendor, that I want to run in a job step, so I can schedule it to run on a …

  RML51

  4 replies

  16 years ago

  By: RML51

• Temp Table to Gather Data

  Could just be that my brain is fried from looking at this for so long, so, I thought that I would p…

  ezlik3sundaymorning

  17 replies

  16 years ago

  By: ezlik3sundaymorning

• How would one create a datasource to use in TSQL?

  I have dozens of stored procedures pointing to another server and at times they need to point to an…

  ShawnTherrien

  6 replies

  16 years ago

  By: Elliott Whitlow

• JOINS with COALESCE

  Hi All, Please fine the following is the scenario: CREATE TABLE #ABC ( id INT IDENTITY(1,1), anoth…

  deepakkn

  2 replies

  16 years ago

  By: Jack Corbett

• Insert Persmisson on a table when using dyanmic script in Stored Proc

  Hi, I have a stored procedure on a sever where i have only execute permission of the proc. I am usi…

  Maruthi Shangar

  1 replies

  16 years ago

  By: Mike01

• Arithmetic overflow error

  Hi, foll. is my query: declare @tbl1 table ( col1 smallint ) insert into @tbl1 select 1 union all …

  ziangij

  1 replies

  16 years ago

  By: arun.sas

• conditional join/and use of case possible??

  I have a table in which the last colum defines the type of table for eg. I have 6 values ,Boolean a…

  kedar.sachin

  4 replies

  16 years ago

  By: Atif-ullah Sheikh

• datetime variable in where condition

  Declare @StartDate datetime,@Start_Date varchar(20) Set @Start_Date='11/16/2009' set @StartDate=cas…

  sudarsanan.kaliyamurthy

  7 replies

  16 years ago

  By: Jeff Moden

• Stored Procedures that converts a table's column data type from char to nchar and varchar to nvarchar

  As i said i have to create a MS SQL Server stored procedure that converts a tables column data type…

  rahulsony111

  2 replies

  16 years ago

  By: Gail Shaw