T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Converting datetime

  Hi Everyone, SELECT GETDATE() result: 2012-01-25 09:44:25.777 Expected result: 20120125094425.777 o…

  krishusavalia

  6 replies

  14 years, 2 months ago

  By: Jeff Moden

• INSERT NUMBER OF ROWS BASED ON NUMBER VALUE IN ANOTHER TABLE COLUMN

  Hi, I want to insert multiple number of rows in a table based on the number recorded in a column on…

  jbhatt2

  15 replies

  14 years, 2 months ago

  By: J Livingston SQL

• Canadian Postal Code and US Zip

  I have an import process where we receive US Zip and Canadian Postal Codes in the same field. We us…

  wmccarty

  11 replies

  14 years, 2 months ago

  By: GSquared

• Same script...different places.

  I've got a Prod system and Stage system I've fired off the same script on both systems. The prod bo…

  graymer

  3 replies

  14 years, 2 months ago

  By: graymer

• union with order by

  Hi All I feeling very odd to ask but i am really really very confused by this how to make order by …

  sami.sqldba

  13 replies

  14 years, 2 months ago

  By: Sean Lange

• Entity Relationship Diagram?

  Anyone know of a good way to map out a db's tables and include all foreign keys and such other than…

  Snargables

  3 replies

  14 years, 2 months ago

  By: Snargables

• Case Statement should have IN

  Hi Friends I have a issue which i am not aware bec myself getting surprise to it.. I have a where c…

  sami.sqldba

  4 replies

  14 years, 2 months ago

  By: Cadavre

• SINGLE_USER MODE ISSUE

  I am setting a db to SINGLE_USER mode in order to then rename some databases: -- Set single User al…

  hindle.steve

  5 replies

  14 years, 2 months ago

  By: HowardW

• Generate custom sequence numbers with Alphabets grouping OR reset group sequence

  Hi, Between a Year date range, I need following output Year_Num, Alphabet 1901, A 1902, B 1903, C …

  iBar

  2 replies

  14 years, 2 months ago

  By: iBar

• SQL Query

  Hi, I have a product database from different brands their are 120 brands and 80,000 products each p…

  billy24

  4 replies

  14 years, 2 months ago

  By: Paul White

• How to copy a role and its permissions?

  Is there a similar command as the one for table to copy everything from a role to another role? For…

  tilew-948340

  20 replies

  14 years, 2 months ago

  By: tilew-948340

• Need help filtering out a record where 1 column makes it not a duplicate

  I have the following query SELECT Distinct SBBACLOAN ,[SBNAME1] ,[SBBRS…

  dndaughtery

  5 replies

  14 years, 2 months ago

  By: Paul White

• Restart Counting with Row_Number()

  I have a puzzle, I need to find out how many days an employee had a certain status in a row, like 1…

  g.griffin

  16 replies

  14 years, 2 months ago

  By: Paul White

• AS400 SQL Query

  Good morning, in light of the fact that I got such great help with a much simpler query yesterday, …

  mbrady5

  6 replies

  14 years, 2 months ago

  By: drew.allen

• Problem with syntax (declaration) in stored proc

  Hi all, I have the following query: -- ================================================ -- Template…

  info-849042

  6 replies

  14 years, 2 months ago

  By: GSquared