T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Required Datamasking script.

  Hi Everyone, Could you please let me know, is it possible to masking the confidential data in sqlse…

  balaji.ganga 68339

  1 replies

  14 years, 5 months ago

  By: ACinAZ

• Row concatenation with FOR XML, but with multiple columns?

  I often use queries like: SELECT * FROM ThisTable OUTER APPLY (SELECT (SELECT SomeField + …

  Cody Konior

  1 replies

  14 years, 5 months ago

  By: spaghettidba

• Query Data based on functions e.g GETDATE()

  Hi Gurus I have a table that have a datetime column, I want to return data based on datetime on pre…

  fortunen

  1 replies

  14 years, 5 months ago

  By: Ninja's_RGR'us

• alternative way for DATEADD on this query

  using this query, is there an alternative approach to achieve my goal? or im doing the right approa…

  Teemo

  9 replies

  14 years, 5 months ago

  By: Cadavre

• Help please on OpenRowSet

  Hi All, I have this query below: Set @TableNameSQL ='Select Count(*) from' + @TableNameVar INSERT…

  jme9314

  1 replies

  14 years, 5 months ago

  By: Performance Guard (Shehap)

• Replace character from generated csv file.

  hi guys, i am generating two csv file through cmdshell and bcp and copying the content of both into…

  ghanshyam.kundu

  1 replies

  14 years, 5 months ago

  By: sturner

• Need help in case statement

  Hi guys, i want to get the result set based on a @startdate if the date is given i need to fetch da…

  ghanshyam.kundu

  2 replies

  14 years, 5 months ago

  By: ghanshyam.kundu

• help with datediff for hours

  Hi all I got a problem to calculate the power on status during a specific date range. Any help woul…

  memostone86

  10 replies

  14 years, 5 months ago

  By: Performance Guard (Shehap)

• Need help for split Multiple Columns into One column..

  Hi, I have a Query Result like following id Name Mark1 Mark 2 Mark3 Mark4 mark 5 -----------------…

  panneer.adms

  2 replies

  14 years, 5 months ago

  By: panneer.adms

• Cursor for List all indexes in SQL Server Instance...

  Hi I need to list indexes in a SQL Server...for that I have written a cursor which will find all in…

  Sgar...

  6 replies

  14 years, 5 months ago

  By: Sgar...

• DB & Server level o/p

  i looking below output can you please help on this plz .. DB NAME SERVER NAME Title L…

  shiv-356842

  2 replies

  14 years, 5 months ago

  By: Sgar...

• first day of month 12 months ago

  Hi I want to be able to calucualte 2 dates based on todays date: ie today is 11/10/2011 (uk date) I…

  carl.meads

  6 replies

  14 years, 5 months ago

  By: Performance Guard (Shehap)

• Stored proc with Database name and servername as parameters

  Hi, I have a sp that looks like this: CREATE PROCEDURE [dbo].[TEST] ( @ServerName VARCHAR(100), @Da…

  PSB

  6 replies

  14 years, 5 months ago

  By: Elliott Whitlow

• Help with Pivot

  I am doing pivot on my result set to get in a desired way but I am facing some issues. I am getting…

  navireddy.g

  13 replies

  14 years, 5 months ago

  By: navireddy.g

• Query For Aduit Reprt

  Hi Friends i need your help in making script to make Aduit report, My manager need to make a query …

  madhuu1905

  2 replies

  14 years, 5 months ago

  By: SQL_By_Chance