T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Replace bad vendor query..

  Is there a mechanism that can do the following: recognize a query when it comes in and replace it w…

  Erin Ramsay

  6 replies

  11 years, 6 months ago

  By: Erin Ramsay

• compare the next row with the previous row of same table

  Hi bros, I need to compare the next row with the previous row of same table and produce nonidentica…

  abhas

  11 replies

  11 years, 6 months ago

  By: serg-52

• Need Help with Old School Pivot

  Hi All, I work with SQLite and need to write a query the old school way to convert rows to columns.…

  htt

  7 replies

  11 years, 6 months ago

  By: htt

• Merging Non overlapping timedates

  Hi All Using SQL 2008 R2 and stuck on this. I have several sets of timedate ranges and I need to me…

  mark 4643

  8 replies

  11 years, 6 months ago

  By: mark 4643

• round the value to the nearest

  I have a column called as NDM$ What I want do it round it the nearest value example I am giving bel…

  Smash125

  6 replies

  11 years, 6 months ago

  By: Sean Lange

• Reduce locking for Insert statement?

  Hi Everyone, There are 2 tables which need to have data inserted into them for auditing purposes. T…

  sqlsurfing

  5 replies

  11 years, 6 months ago

  By: sqlsurfing

• How to perform mathematical formula without using case.

  I am having 4 Columns Qty decimal(12,3),CF1 Decimal(12,3),CF2 Decimal(12,3),Flag TinyInt. I want to…

  shahi.alokchandra

  15 replies

  11 years, 6 months ago

  By: Luis Cazares

• Creating Comma seperated list of details from multiple columns

  Hi All, I am trying to find a way to add into a table a flattened (comma seperated list) of email …

  doyle_31

  16 replies

  11 years, 6 months ago

  By: cnu1252

• display values upto 1 decimal without function.

  Hi All, I am having values as below: 99.87 99.96 8.67 And my output should be as: 99.8 99.9 8.6 How…

  abhas

  20 replies

  11 years, 6 months ago

  By: DonlSimpson

• data type

  .

  Tam Le 7

  1 replies

  11 years, 6 months ago

  By: spaghettidba

• SQL Server says there's a self join in my view. In my opinion there's none...

  Hi folks, i'm building a view for which i would use fulltext search. To use fulltext search the vie…

  michael.molz

  2 replies

  11 years, 6 months ago

  By: michael.molz

• Hot to Get Number of days for given date range.?

  --From the rows I want to know how many number of days a person was active for the given date range…

  vineet_dubey1975

  10 replies

  11 years, 6 months ago

  By: Luis Cazares

• Change Column order in dynamic pivot

  Hello friends, One more query from me today 🙂 I am creating dynamic pivot and my column order is as…

  abhas

  1 replies

  11 years, 6 months ago

  By: Eugene Elutin

• issue with EXEC sp_executesql

  Hi Friends, How to insert resultset of EXEC sp_executesql into temporary table? I tried below opti…

  abhas

  6 replies

  11 years, 6 months ago

  By: Gail Shaw

• Stored procedure with unavailable server reference

  We have a stored procedure that makes a decision to pull records from one of two servers. If one of…

  raysteve43

  2 replies

  11 years, 6 months ago

  By: ScottPletcher