T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Last Windows restart?

  Is there an easy way within SQL Server (no xp_cmdshell or anything like that) to get the last Windo…

  Pam Brisjar

  4 replies

  14 years, 6 months ago

  By: Pam Brisjar

• Index Hints work but why do I need them all of a sudden?

  Hi there, Express R2: A multi-table/inter-server script that needed < 2min to finish yesterday c…

  Arthur Kirchner

  3 replies

  14 years, 6 months ago

  By: Gail Shaw

• Two questions about Index de/fragmentation

  Hi there, I used the script on this site (Example D. Using sys.dm_db_index_physical_stats in a scri…

  Arthur Kirchner

  4 replies

  14 years, 6 months ago

  By: Arthur Kirchner

• Merge Join and Implementing type 2 need Suggestions

  CREATE TABLE [dbo].[StagingIssuer]( [AsODate] [datetime] not NULL, [AssetSK] [varchar](100) not N…

  gopinathreddy.d

  2 replies

  14 years, 6 months ago

  By: gopinathreddy.d

• NTILE help

  I have the following table of departments, members, and actions: CREATE TABLE [dbo].[GroupMembersh…

  Mike Scalise

  8 replies

  14 years, 6 months ago

  By: ChrisM@home

• Really Odd and Seemingly Difficult Update, One Piece of Data at a Time.

  Hello Everyone I hope that you all are having a very nice day, and are ready for the upcoming holid…

  AndrewSQLDBA

  6 replies

  14 years, 6 months ago

  By: ChrisM@home

• How to put like operator in a where clause on a list?

  I have two tables 1- Tracking 2- DomainsToExclude Tracking table has following list of columns: 1- …

  Shamshad Ali

  4 replies

  14 years, 6 months ago

  By: Sean Lange

• How to get result(output) column values based on given group with conditions

  Hello All, please help me in this scenario, i tried a lot but somehow seems to be my view is wrong …

  asita

  7 replies

  14 years, 6 months ago

  By: asita

• Hi i want modify the below store procedure.

  Hi This is the code SELECTRight(Replicate('0',15) + AccountNumber,15) AS 'AccountNumber', BankN…

  unnati.patel513

  2 replies

  14 years, 6 months ago

  By: unnati.patel513

• I want create a XML File using the T-sql for below format

  Hi, I want to create xml file using T-sql.. XML file is below format. please help me how i can crea…

  unnati.patel513

  7 replies

  14 years, 6 months ago

  By: unnati.patel513

• Syntax Question

  When I try to execute the following: IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'CreditR…

  TheRedneckDBA

  1 replies

  14 years, 6 months ago

  By: Cadavre

• Populate Start and End Time from Previous End Time

  --I need to compute a series of starting and ending datetime values, --based on the value of the pr…

  MattieNH

  9 replies

  14 years, 6 months ago

  By: Jeff Moden

• i need to do a reverse lookup on zip and get city and state for us and canada.

  At this point i havent done anything. I'm assuming i'll have to bring down a file of sort and so on…

  Snargables

  16 replies

  14 years, 6 months ago

  By: Possinator

• Am I Blind? - Duplicate key row

  I have a table: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABL…

  miernik.robert

  7 replies

  14 years, 6 months ago

  By: SQLRNNR

• Prioritize a JOIN - get just one option

  SELECT * FROM table1 t1 INNER JOIN table2 t2 on t1.col = t2.col OR …

  thhamlin

  8 replies

  14 years, 6 months ago

  By: thhamlin