T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How To Get a row(date) for each month

  Hi All, I need to get a minimum month and year from a table and then a row for every month/year up…

  Teee-SQL

  5 replies

  12 years, 10 months ago

  By: Kingston Dhasian

• Transaction Isolation Level with CTE

  How do you handle the “SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED” with common table expressi…

  SQL_Enthusiast

  6 replies

  12 years, 10 months ago

  By: Sean Pearce

• Finding duplicate rows with multiple fields for comparison

  I've taken a look at the scripts and forum posts on the site regarding finding duplicate rows, but …

  Mark Harley

  4 replies

  12 years, 10 months ago

  By: Mark Cowne

• Hi guys this urgent reg int to varchar conversion

  I am a fresher dba i got a task where i need to convert int value to varchar please help me with th…

  ak08

  4 replies

  12 years, 10 months ago

  By: ak08

• Conversion failed when converting from a character string to uniqueidentifier

  Hello, I am trying to do an update based on a join condition and I am getting the following error: …

  Pyman

  1 replies

  12 years, 10 months ago

  By: Pyman

• Converting nvarchar value to int

  I've a column name called "Codes" and the datatype is nvarchar. The data looks like X200, 516, XD1,…

  sql1411

  4 replies

  12 years, 10 months ago

  By: sql1411

• Select full month number (with 0)

  Hi, I use DATEPART(month, myDate) or MONTH(myDate) the resut is: 2 (if myDate is 2013.02.03). I wou…

  gmac 41947

  28 replies

  12 years, 10 months ago

  By: ScottPletcher

• Calculate Previous Business Day Exclude Saturday, Sunday and Holiday

  Hi, My name is Kashif, I am very new in sql server, I want create a UDF function that will return a…

  kashif.special2005

  2 replies

  12 years, 10 months ago

  By: Alan Burstein

• Simple MAX Query not working

  Im confused on why this query is not working.. Data - vend_i dept tot_wgt 1 1 …

  bharathimc02

  6 replies

  12 years, 10 months ago

  By: Nevyn

• can any one give me the answer of my query why I am getting the error message

  use [12] go CREATE TABLE Test1 ( TestID uniqueidentifier CONSTRAINT Test_TestID_Default DEFAULT new…

  mca.deepak3335

  4 replies

  12 years, 10 months ago

  By: Jason-299789

• qry options

  I want to do this. select count(*) from ( select col1,col2,......col18 from REVemployee.tbemp group…

  Tara-1044200

  1 replies

  12 years, 10 months ago

  By: Eugene Elutin

• Rollback statement in T-SQL

  The functionality of Rollback statement in T-SQL is such a way it rollbacks to the outermost nested…

  VSSGeorge

  6 replies

  12 years, 10 months ago

  By: Eugene Elutin

• using Correlated subQuery in Join not working

  I have a large query that is returning multiple rows that I tracked down to my jornal table. It has…

  tshad

  9 replies

  12 years, 10 months ago

  By: Phil Parkin

• subquery returning more than one value

  I have two tables, a and b. I want to select all from table a (except where proc_num is null) and …

  Denise McMillan

  10 replies

  12 years, 10 months ago

  By: Alexander Suprun

• Creating hierarchical metadata based on DMVs or system tables

  I have a requirement to archive & purge my OLTP data. The database is a tightly defined relati…

  SQLCurious

  2 replies

  12 years, 10 months ago

  By: SQLCurious