T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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

  13 years, 10 months ago

  By: Dwain Camps

• optimize views

  Does anyone have any tips on optimizing views?

  ReginaR1975

  7 replies

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months ago

  By: Hardy21

• SQL query

  I have below table: ColA ColB ColC ColD ColE ColF Host1 P PP dateA 98 Host1 Q …

  dsrapid

  3 replies

  13 years, 10 months ago

  By: vinu512

• get the actual password from aspnet_memberships

  I want to select the password from the aspn_membership (.NET memberships tables) and decrypt it a…

  ali.mahmoud.habib

  6 replies

  13 years, 10 months ago

  By: Steve Jones - SSC Editor

• Crosstab or Pivot variant - stuck!

  Ok, here goes. I have a table, which sits within my CRM and stores "questionnaire" type information…

  ProKelly

  9 replies

  13 years, 10 months ago

  By: ProKelly

• Proc Optimization

  We have one procedure [say P1] having multiple inserts to a table [Say Target1] resulting from join…

  sqlnaive

  21 replies

  13 years, 10 months ago

  By: sqlnaive

• Trigger not firing in production but does in non-production

  I have a trigger that is firing with out issue in non-production but the same exact code is failing…

  russ960

  12 replies

  13 years, 10 months ago

  By: russ960

• case statement in where clause

  How do you write a case statement like this for the <> 2 part? select field1 from tbl1 where …

  ReginaR1975

  8 replies

  13 years, 10 months ago

  By: Daxesh Patel

• A big INSERT INTO statement and rolling it back

  If I had a single INSERT INTO statement that was very big, what would happen to the transaction log…

  Golfer22

  8 replies

  13 years, 10 months ago

  By: Gail Shaw