T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• When I use multiple cases only the first one gets executed

  Hi Everyone, I have users profiles in a table in my database but some of them have wrong data. i.e,…

  labri

  8 replies

  13 years, 9 months ago

  By: ChrisM@Work

• Need Script to List Foreign Keys for a Table - Error TRUNCATING Table

  I'm looking for a script that List all Foreign Keys for a Table. I had a few but I can't locate the…

  Welsh Corgi

  10 replies

  13 years, 9 months ago

  By: deepzzzz

• How to Display current week number for a year

  Hi, Can some one tel me how can I display current week number in SQL? I need to use this function i…

  84gopi

  12 replies

  13 years, 9 months ago

  By: Ant-Green

• To Insert rows into a Compressed table..

  Hello, I compressed a table XYZ in Sql Server 2008. Now i need to insert some thousands of rows fro…

  sqlstunner

  4 replies

  13 years, 9 months ago

  By: Perry Whittle

• Calculated column Only for Insert

  I have a table with two columns created date and mofified date. I have a condition like 1. When the…

  Sony Francis @EY

  6 replies

  13 years, 9 months ago

  By: Jeff Moden

• update pk in table1 and carry it to update fk in table2

  I have a process where I have to copy rows from two tables and update a few columns, one of which i…

  Matthew Cushing

  5 replies

  13 years, 9 months ago

  By: Lynn Pettis

• How to freeze the TSQL session while we executing the query again again?

  I'm using one query window and trying to tune the Query, if i runs twice or thrice it's taking Old …

  Saravanan_tvr

  4 replies

  13 years, 9 months ago

  By: Ant-Green

• Transform data into 2 more columns

  Hi, I have data in a table wid 3 columns. Invoice_no, item, price.... example:- Invoice_no item …

  Skybvi

  4 replies

  13 years, 9 months ago

  By: Skybvi

• odd sproc behavior

  I have a sproc that performs a multi-table insert. Some of which is done via dynamic SQL. When my…

  jerrycutshaw

  4 replies

  13 years, 9 months ago

  By: Dwain Camps

• Grouping and Sorting sequential data by street address

  Hi I was wondering if someone could help me. I have a huge table that stores product delivery route…

  darthurfle

  7 replies

  13 years, 9 months ago

  By: Dwain Camps

• WITH DROP_EXISTING = ON Fails before I create the INDEX on SQL Server Instance

  I execute this statement on my PC and it works: CREATE NONCLUSTERED INDEX IX_WorkOrder_ProductID …

  Welsh Corgi

  12 replies

  13 years, 9 months ago

  By: Welsh Corgi

• How identify the last inserted values in select query

  Hi guys, How to identify the last inserted values in "select Query" Example Query : select * from i…

  ranganathanmca

  9 replies

  13 years, 9 months ago

  By: Jeff Moden

• script to copy missing data

  SCENARIO, i have tbl1, tbl2,tbl3 in qa and prod. tbl1(id int identity(1,1),DomainName varchar(250),…

  FTdenali

  2 replies

  13 years, 9 months ago

  By: Jeff Moden

• Create 15 min inc time matrix?

  I have an interesting query to put together and have a general idea but wonder if someone out there…

  tacy.highland

  81 replies

  13 years, 9 months ago

  By: tacy.highland

• Converting Datetime2(0) to Datetime

  Whenever I try to convert this - it says "Out of range value" has anyone had any luck converting a…

  tmitchelar

  9 replies

  13 years, 9 months ago

  By: tmitchelar