T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Year summary report - GROUPING SETS OR ROLLUP

  Hey all, I've been trying to figure out how to setup a report such that the column names are the mo…

  salkobi

  8 replies

  11 years, 2 months ago

  By: Dwain Camps

• Easy script help (I think!?)

  I am somewhat new and for that please forgive me but I need to create this script and it is driving…

  jrodriguez 62807

  4 replies

  11 years, 2 months ago

  By: jrodriguez 62807

• Pivot when you dont know amount of columns and coloum names

  I am trying to figure out how to pivot a temporary table. I have a table which starts with a date b…

  Edward-445599

  2 replies

  11 years, 2 months ago

  By: Jason-299789

• how to rewrite query to avoid duplicate records (across columns)

  Hello Good Morning All, Happy New Year, Could you please help to rewrite the below two queries (s…

  asita

  13 replies

  11 years, 2 months ago

  By: ScottPletcher

• How to convert uniqueidentifier from string to use in a join / where clause

  Hi, I am wanting to get the job name based on sys.sysProcesses.[Program_name] column. Why is this q…

  DennisPost

  6 replies

  11 years, 2 months ago

  By: ChrisM@Work

• NEED COLUMN NAMES FROM TABLE DYNAMICALLY

  Hi Team, I need to retrieve columns names(instead of select * from) as single row from table in dyn…

  Kannan Vignesh

  18 replies

  11 years, 2 months ago

  By: Ed Wagner

• Concatenating Binary Rows

  Hi guys, I read this link and I have exactly the same problem: http://www.sqlservercentral.com/Foru…

  salardx

  1 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• Validating T-SQL

  Is there a way to validate a string of T-SQL in T-SQL? In this case, I generate a bunch of code tha…

  schleep

  14 replies

  11 years, 2 months ago

  By: schleep

• OPENROWSET(BULK @path )

  need the line : (SELECT * FROM OPENROWSET(BULK 'D:\Work\Appspace\Currency\currency.xml', SINGLE_CLO…

  ikrami2000

  12 replies

  11 years, 2 months ago

  By: ikrami2000

• Mapping Hierarchical Relationships

  Hey all, I’m trying to build something which allows different user groups to inherit properties fro…

  Xedni

  4 replies

  11 years, 2 months ago

  By: Jeff Moden

• need help to pivot

  This is my dataset, batch_IddaerahKutipanfigure ------------------------------------------------…

  Qira

  2 replies

  11 years, 2 months ago

  By: zhll2046

• Help me find the best index for a specific query

  This is my table: use tempdb go if object_id('Data', 'u') is not null drop table Data go with temp…

  _simon_

  7 replies

  11 years, 2 months ago

  By: ScottPletcher

• Rows to Column

  Hi All, Season's Greetings!! Came across one scenario not able to find out how to do it.. Below is …

  BI_NewBie

  5 replies

  11 years, 2 months ago

  By: Jeff Moden

• Stored procedure if pass two parameters i got the result but if i pass one parameter i did not get any result but in the result message box giving the result like "Command(s) completed successfully.", Kindly help to resolve this issue.

  ALTER PROCEDURE [dbo].[SP_NiceUserresultsearch_test] -- Add the parameters for the stored procedur…

  DBA.k

  3 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• UTC date from an integer

  Hi all, I'm trying to get the UTC date from an integer. See my SQL below: Declare @unix_date bigi…

  stricknyn

  2 replies

  11 years, 2 months ago

  By: ScottPletcher