T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Aggregate Query Help Required

  Hi, I have the following table: CREATE TABLE [dbo].[Table_1]( [ID] [int] IDENTITY(1,1) NOT NULL, …

  dec_obrien

  4 replies

  11 years, 5 months ago

  By: dec_obrien

• Best way to insure proc makes it

  Hi, I have a stored proc that pulls data from a very old pervasive database into SQL. This process …

  krypto69

  11 replies

  11 years, 5 months ago

  By: krypto69

• Search Millions of Column Values in Another Column

  ...

  craig-404139

  3 replies

  11 years, 5 months ago

  By: serg-52

• Performance of 'OR' in a where clause

  I don't have the code in front of me, so just wondering if there's a general principal at work here…

  homebrew01

  4 replies

  11 years, 5 months ago

  By: homebrew01

• Can I use WHILE in a CTE?

  Hi, I would like to have a while loop in a CTE but I wonder if that will work out the way I planned…

  michielbijnen

  13 replies

  11 years, 5 months ago

  By: TomThomson

• Get data in 2 columns

  Hello, I am currently working on extracting data from a text file and loading into sql server. Thi…

  vsan82

  1 replies

  11 years, 5 months ago

  By: Luis Cazares

• How does transaction rollback across multiple database

  I have a wrapper stored procedure ProcMain_wrapper that executes in one main dataabase and it calls…

  Guras

  2 replies

  11 years, 5 months ago

  By: ScottPletcher

• CDC activities on receiving machine?

  Is there a way for me to set up CDC so that all the processing (SQL Agent, etc) happens on the mach…

  andre.quitta

  3 replies

  11 years, 5 months ago

  By: MMartin1

• Help with an OR query

  Hi All, Am hoping someone can help with this as it's turning me grey! I have this query currently: …

  Kazmerelda

  8 replies

  11 years, 5 months ago

  By: Kazmerelda

• Having Issues With Date Conversion from a String

  I have a table (TBarsImport) with the following varchar column defined, which contains a date/times…

  mail 41752

  5 replies

  11 years, 5 months ago

  By: mail 41752

• linked server - GO or no GO ??

  My objective is to create a stored procedure, so I can schedule this task. First, I want to get the…

  inevercheckthis2002

  4 replies

  11 years, 5 months ago

  By: ScottPletcher

• Split string to show only customer

  The data we are getting from our shipping company has the customer name and customer number attache…

  dwilliscp

  19 replies

  11 years, 5 months ago

  By: VSP

• Adding two month

  This statement adds two additional months to which is fine : DATENAME(MM,dd.date)+ ' ' + DATENAME(D…

  kd11

  7 replies

  11 years, 5 months ago

  By: kd11

• Can somebody help with this sql query behavior -URGENT

  Hi.. am running the below sql statement on a database... select c.MID, c.RecordDate, sum( c.A ) as …

  Agnii

  5 replies

  11 years, 5 months ago

  By: Matt Miller (4)

• User Defined Function that returns Start Date and End Date

  Hi Everyone. Does anyone have a UDF that accepts a Month and Year and returns Start Date and End Da…

  ganteng1

  8 replies

  11 years, 5 months ago

  By: David Burrows