T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Reorder a custom order column

  Hi, Been stuck on this for a little while and hoping that someone can help me figure out my logic p…

  matak

  12 replies

  13 years ago

  By: matak

• How to show Carriage Return Char(13) in XML as real CR instead of tag.

  Hi, I'm using a neat query to concatenate strings. It is using XML to do. I had 200.000 rows to be …

  Harry Drenth

  9 replies

  13 years ago

  By: Lynn Pettis

• Combine multiple combinations to one

  Hi, The following test condition : IF object_id('tempdb..#testEnvironment') IS NOT NULL BEGIN DRO…

  RZ52

  2 replies

  13 years ago

  By: RZ52

• Just a random observation with 'WITH'

  Following is my observation with 'WITH' I executed the below query SELECT * FROM Sales.SalesOrderDe…

  Shadab Shah

  2 replies

  13 years ago

  By: Lowell

• Performance ISSUE by USING CURSOR HELP !!!!

  Hello Mate, I have the following TSQL but I meet a performance issue on Phase 3. Phase 1 and Phase …

  ERIC CRUDELI

  24 replies

  13 years ago

  By: ChrisM@Work

• can't view all db_users when select * from sys.databaseprincipals

  Per msdn, there is a permissions restrictions where,,, Permissions --------------------------------…

  KoldCoffee

  18 replies

  13 years ago

  By: polkadot

• how to show results in pivot in sql please?

  Hello All, how to show results in pivot format, please assit me to get the desired output as attach…

  asita

  4 replies

  13 years ago

  By: asita

• How to concatenate group of rows

  Hi, I have a data structure as followed : [Name], [Task] and the data is : John, task1 John, task2 …

  RZ52

  12 replies

  13 years ago

  By: RZ52

• How to create a calendar table for 65 weeks (not the default of 53 weeks) ?

  I have a cte script to create a calendar table for 53 weeks, starts at 2011-01-01 (week 1, Saturday…

  kevin_nikolai

  2 replies

  13 years ago

  By: kevin_nikolai

• system tables and views

  Does a database diagram exist of SQL Server's system tables? I am looking for documentation that …

  polkadot

  5 replies

  13 years ago

  By: Lynn Pettis

• problem with union

  Hi all, I have a problem with my "union" query, this a sample of my query. What I'd like to obtain …

  kayser.b

  4 replies

  13 years ago

  By: kayser.b

• I think I already know the answer but...

  I suspect the answer is going to be "No" but thought I'd check with more experienced heads than my …

  Erin Ramsay

  14 replies

  13 years ago

  By: sqlprincess

• SQL Query Problem: How to aggregate discount percentages?

  I have a scenario whereby I need to aggregate n number of discounts to get a total discount %. Eac…

  jezman

  7 replies

  13 years ago

  By: Sergiy

• Alpha Numeric number Generation

  Hello, Need help with in writing a Stored Procedure for Auto Alpha Numeric Generation. If I pass…

  sqlenthu_11

  16 replies

  13 years ago

  By: ScottPletcher

• Extract Saturday through Friday as the weekly date range

  I have data with attendance hours/dates for every day of the month/year. I need to create a query w…

  fergusoj

  6 replies

  13 years ago

  By: fergusoj