T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• CROSS APPLY

  CROSS APPLY ( SELECT col = CASE WHEN MAX(col) = MIN(col) THEN MAX(col) ELSE NULL END )

  Minnu

  3 replies

  13 years, 6 months ago

  By: drew.allen

• Pivot a table

  Hi All, following is the result of my query Year_Month.........cat1_per......cat2_per........cat3_…

  myjobsinus

  3 replies

  13 years, 6 months ago

  By: drew.allen

• Return value from CLR Assembly

  I have a C# assembly that returns a string. I created an SP to call this assembly and it works. But…

  mickyc1

  2 replies

  13 years, 6 months ago

  By: Lowell

• SSRS

  Hi, Anyone knows about this? I want to make SSRS reports based on cube(SSAS). Now further more I wa…

  hmsanghavi

  1 replies

  13 years, 6 months ago

  By: patrickmcginnis59

• Determine unique combinations of permissions assigned to users

  I need to determine the unique combinations of group permissions assigned to users. Currently, per…

  whenriksen

  4 replies

  13 years, 7 months ago

  By: Dwain Camps

• Combine different rows based on sequence

  Hello All, I have some really ugly data coming in from several files. I am using SSIS to import int…

  Chrissy321

  5 replies

  13 years, 7 months ago

  By: Dwain Camps

• TSQL to join two tables to calculate the total based on the date range

  Hi I have 2 tables Rates and Records. RATES table country fromdate todate…

  xXShanXx

  15 replies

  13 years, 7 months ago

  By: TomThomson

• Need the output in excel

  Hi, I have this below script and need the output in excel in D:\Reports folder. Anyone can help me …

  espanolanthony

  8 replies

  13 years, 7 months ago

  By: kl25

• Change a query using GETDATE to include time?

  Hi I have this query - SELECT * FROM [GATE].[dbo].[DATA_CLOB] WHERE RAW_CLOB LIKE 'AAA|E0221002|_|…

  sqlrd22

  2 replies

  13 years, 7 months ago

  By: sqlrd22

• Large Structure of a table

  I need help regarding the issue having on performance and size. We have a Database : (History_price…

  sqlenthu_11

  5 replies

  13 years, 7 months ago

  By: Sean Lange

• Get the average of the data in the table.

  Team, I have a set of data for perticular day.Plesae help me in writing a sql query to get the av…

  Mithra

  2 replies

  13 years, 7 months ago

  By: subbu1

• Flag field update and insert vs all columns update vs delete and insert

  Hi All I have a data warehousing scenario related to Updates and SCD. In our ETL procedure, we cur…

  koustav_1982

  2 replies

  13 years, 7 months ago

  By: koustav_1982

• REVISITED: select rows where values appear consecutively

  I received some great suggestions, but didn't get quite what I wanted mainly because I didn't provi…

  jkw

  1 replies

  13 years, 7 months ago

  By: Matt Miller (4)

• Should I use a nested subquery?

  SELECT DISTINCT RepairSheetH.RepairSheetNr, Vehicle.unitnr, Vehicle.groupid, Vehicle.brandId, Veh…

  thomasrichardson2000

  14 replies

  13 years, 7 months ago

  By: thomasrichardson2000

• Dumb? SQL Question

  I'm working on a dynamic SQL builder and came across the following by accident. -- Some backgrou…

  souLTower

  4 replies

  13 years, 7 months ago

  By: souLTower