T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Using aggregate function for datatime column

  Hello, I have a table for which structure is below: nCounter numeric vInOutTag varchar(1) nEmpNo nu…

  milindgs20

  9 replies

  13 years, 10 months ago

  By: Ninja's_RGR'us

• traspose columns dynamically

  Hello I have a table that has a numeric primary key and other columns like personName, assignedgned…

  edotom

  5 replies

  13 years, 10 months ago

  By: kramaswamy

• Bulk Insert from SAS (or openrowset)

  We need to pull some data in from our SAS db into a SQL Server 2005 database. From what I can tell …

  Marcia Q

  9 replies

  13 years, 10 months ago

  By: db2mo

• Script result display in messages not in Grid

  hi, SET NOCOUNT ON DECLARE @crdate DATETIME, @hr VARCHAR(50), @min-2 VARCHAR(5) SELECT @crdate…

  SQL Galaxy

  5 replies

  13 years, 10 months ago

  By: kramaswamy

• query pro's please help me with this...

  create table #drivertable( id int, name varchar(10), status varchar(2), c_group int ) Insert into #…

  Chinna

  8 replies

  13 years, 10 months ago

  By: kramaswamy

• UPDATE multiple columns - Are column values calculated and updated in order specified?

  Hi, I know multiple columns can be updated in a single UPDATE statement like this: UPDATE t SET fie…

  Jamie Julius

  13 replies

  13 years, 10 months ago

  By: Matt Miller (4)

• How to modify XML at specific node SQL SERVER 2005..

  I have an XML of the Form declare @XML xml declare @tmp1 int,@tmp2 int declare @New_ACC_ID int set …

  MVIT

  4 replies

  13 years, 10 months ago

  By: MVIT

• SQL Query To Select Records Based on the Group Values

  This seems like an easy query, yet all my attempts have failed to find the answer. Mainly I have 2 …

  TTboy

  3 replies

  13 years, 10 months ago

  By: TTboy

• Need to Add Current Date to a New Table

  I am trying to automate a process. In the code, I am creating a backup of a table before I modify i…

  ducksql@gmail.com

  2 replies

  13 years, 10 months ago

  By: ducksql@gmail.com

• stuck on a copy query

  Hey reader, first of all thanks for reading my problem ! The issue i'm having is that i'm reading …

  p.van.kuyen

  10 replies

  13 years, 10 months ago

  By: p.van.kuyen

• Urgent: Query hlp needed

  Hi Techies, Attached is the sql statements to create 3 tables and insert dummy data in all three ta…

  kotteesh

  8 replies

  13 years, 10 months ago

  By: kotteesh

• Case Statement Error

  Hello , Can you please tell me wheteher i have written the following code correctly or not... sele…

  maverick_immortal

  2 replies

  13 years, 10 months ago

  By: Steve Jones - SSC Editor

• Query Mystery

  Hello Friends ….I’ve a table which has 4 partitions and those partitioned table are purged by a job…

  sqlquest2575

  3 replies

  13 years, 10 months ago

  By: sqlquest2575

• One of those days.... datatype conversion error

  I have been logging data from perfmon to a SQL Server DB. The Date/Time info is stored as CHAR(24)…

  mnDBA

  5 replies

  13 years, 10 months ago

  By: Sean Lange

• Delete data older than 30 days, char to datatime conversion.

  Hi, I need to delete data older than 30 days. Column that I filter on is char and has date formatte…

  uncle_enzo

  8 replies

  13 years, 10 months ago

  By: Ninja's_RGR'us