T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• ODSOLE Class Not Registered - (32 bit COM object in a 64 bit environment)

  I'm running SQL 2008R2 and W2k 2008R2. When I call a COM object through a stored proc using sp_OACr…

  AVB

  8 replies

  11 years, 5 months ago

  By: Alexandr Kalenkov

• how to create Stored procedure?

  Hi yesterday i was trying to create Stored procedure but it fails i don't know why CREATE proc GetB…

  Elliswhite

  16 replies

  11 years, 5 months ago

  By: saravanan.a 88885

• can somebody help me with creating instead of trigger..

  Hi guys I need to create an instead of trigger which prevents inserting the year of 2009,2010,2011 …

  Akayisi

  2 replies

  11 years, 5 months ago

  By: Akayisi

• INSERT only when value has been updated?

  I have database that holds column depicting various events and the last time that the event occurre…

  inevercheckthis2002

  9 replies

  11 years, 5 months ago

  By: mister.magoo

• stored procedure with OUTPUT parameter in dynamic sql problem

  Note: @procName,@strAccount,@intHospital,@patType are passed to this procedure from another proce…

  Guras

  2 replies

  11 years, 5 months ago

  By: Guras

• Forcing the existence of date records for a graph of counts over time

  I'm pretty sure I know the answer to this, but I figured I would ask in case I'm missing something …

  pietlinden

  2 replies

  11 years, 5 months ago

  By: pietlinden

• compare and insert record

  Hi All, I am having below two tables: 1) TableA : Which contains 5 columns(Column1,..........Column…

  abhas

  4 replies

  11 years, 5 months ago

  By: Umer Akram

• Looking for the advisable sql sentence

  Hi, Let’s have the next set of data Incident # 162002982 has among the results 2 different id’s, th…

  cphspain

  3 replies

  11 years, 5 months ago

  By: serg-52

• Please Help. My Stored Procedure Doesn't Work

  Hi Everyone. Can someone please tell me why the following query doesn't work? USE [PAULS TEST DATAB…

  ganteng1

  4 replies

  11 years, 5 months ago

  By: Gail Shaw

• getting sum values for non overlapping rows by datetime

  I want to count persons for non overlapping intervalls by room number. Here the data: SET DATEFORM…

  ot 60857

  4 replies

  11 years, 5 months ago

  By: serg-52

• Defrag MASTER and MSDB

  On a 2008r2 server, I ran the frag utility against master and msdb and noticed they were severely f…

  fizzleme

  7 replies

  11 years, 5 months ago

  By: fizzleme

• Getting SQLHandle from XML into sys.dm_exec_sql_text

  Hi all, Ive ran some Event Notifications collecting some blocking data, im now trying to extract t…

  Staggerlee

  6 replies

  11 years, 5 months ago

  By: mxale

• Making the two select statements into one

  Hi I have a scenario where the second SELECT statement in my query has to be removed such that the …

  VSSGeorge

  6 replies

  11 years, 5 months ago

  By: VSSGeorge

• UNION followed by IF ELSE

  I get a red squiggle below the first IF statement. Can't figure out the correct syntax. Any suggest…

  JJR333

  2 replies

  11 years, 5 months ago

  By: JJR333

• Incorrect syntax near the keyword 'pivot'.

  Hi All, i'm struggling with one Syntax error , any help is appreciate‎ CREATE TABLE #ToolComplianc…

  ramineni.suresh661

  4 replies

  11 years, 5 months ago

  By: ramineni.suresh661