T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How to convert a string into datetime, if fails return null

  Hi Guys, I am having a project need to convert a varchar(255) column from a table into datetime, if…

  mr.zl8888

  9 replies

  14 years ago

  By: spaghettidba

• Query using date

  Hi Guys, Kindly please help me to pullout records using the date. I would like to pull out this rec…

  Kaniguan_SQL

  5 replies

  14 years ago

  By: Sean Lange

• Using multiple counts to return results

  Hey guys, I have a table (MyTable) in the format; Person (varchar) Company (varchar) Flag (bit) (Th…

  McSQL

  6 replies

  14 years ago

  By: McSQL

• T-SQL data retrival query

  Hi, I have scenario where table field names are in short terms. Field actual name is extracted usin…

  hunmunnar

  5 replies

  14 years ago

  By: hunmunnar

• Delete data data older than 3 moths from a sql table having more than 16 millions of data

  I need to Delete data data older than 3 moths from a sql table having more than 16 millions of data…

  Giridhar A

  2 replies

  14 years ago

  By: Ian_McCann

• To get the result without using joins (not subquery)

  Hi, I have 2 tables with below data and eid is the common column in both tables. I want to retrieve…

  NLV

  2 replies

  14 years ago

  By: Gail Shaw

• SSIS

  Hi, I need to create a package in SSIS 2008 for the following task: I have a database name OMB. In …

  dsrapid

  2 replies

  14 years ago

  By: Rock from VbCity

• Need to insert a new integer that is pseudo-random and unique to a group (not unique to the entire table)

  We have a column in a table that needs to contain pseudo-random integer. This integer needs to be …

  Maxer

  27 replies

  14 years ago

  By: Dwain Camps

• optimize views

  Does anyone have any tips on optimizing views?

  ReginaR1975

  7 replies

  14 years ago

  By: Evil Kraig F

• Delete statement

  I have to delete 401 records from a data table. The 401 records have a common primary key and 401 s…

  Bron Tamulis

  11 replies

  14 years ago

  By: David Webb-CDS

• Getting an error Msg 512, Level 16, State 1

  Dear all, I'm getting an error as given below while executing the query: Msg 512, Level 16, State 1…

  ramsai1973

  3 replies

  14 years ago

  By: drew.allen

• Find which rows have a column value that is less than the previous row's column value

  Hi Guys, I know this should be simple to code but i've hit a wall trying to produce something simpl…

  Pianoman

  21 replies

  14 years ago

  By: Jared

• Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '.'.

  Dear All, I''m getting an error msg on executing the below given SQL query: Msg 102, Level 15, Stat…

  ramsai1973

  3 replies

  14 years ago

  By: Gail Shaw

• Generate Statistical Number Series

  --exec [dbo].[GenerateSeries] 100 alter Procedure [dbo].[GenerateSeries] @int bigint=NULL AS BE…

  vineet_dubey1975

  7 replies

  14 years ago

  By: Dwain Camps

• Modify XML attribute value based on matching data

  Hello, I am using SQL Server 2008 R2 and facing an issue to update XML attribute value. I have a re…

  Hardy21

  2 replies

  14 years ago

  By: Hardy21