T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• event is occurring between today at 1:00am and tomorrow at 12:59am

  Hello, I need a query that finds event is occurring between today at 1:00 am and tomorrow at 12:59 …

  dallas13

  2 replies

  13 years ago

  By: Sergiy

• select rows into colums

  Dear T-sqlérs, I have a test table (see script below) with the following result namelength balk17…

  SQLServerForum.nl

  7 replies

  13 years ago

  By: Cadavre

• Sql Query

  I have to return one result set by writing two different logic. Both of the logic are very complex.…

  SqlServerLover

  6 replies

  13 years ago

  By: SqlServerLover

• For Learning

  I want to improve my DB Knowledge , i have experience in MS-SQL and ORACLE. My Problem is when i fa…

  saravanan.kuttyy

  4 replies

  13 years ago

  By: saravanan.kuttyy

• Stop large queries from running

  Hi, I have a query window with a lot of code but I do not want to run it entirely in error, is ther…

  akberali67

  6 replies

  13 years ago

  By: Eugene Elutin

• How can I create intervals fro start-dates only

  Let's assume we have 1) A key value, like a product number 2) and a ValidFrom date, like this MyPro…

  Peter Pirker

  3 replies

  13 years ago

  By: Peter Pirker

• outputting the Stored Proc output to Text File Pipe (|) Seperated with Headers

  Command to run Exec Rpt_OrderReport '1/1/2013' , '1/31/2013' Need a code which will save the output…

  skb 44459

  1 replies

  13 years ago

  By: Eugene Elutin

• Pivot Query with Count

  Hi there I am fairly new to SQL Server TSQL and I have a strong MS Access background. I can't get m…

  clyde 73016

  9 replies

  13 years ago

  By: Jeff Moden

• Get missing records

  Hi, I have a table #TransDetail CREATE TABLE #TransDetail ( ID INT IDENTITY(1,1) PRIMARY KEY, Nu…

  PSB

  7 replies

  13 years ago

  By: Dwain Camps

• Backup large database to multiple files

  Hi everyone, I manage 100+ SQL servers and some of them contain over 120 – 800 GB + databases. I go…

  pehlebhiayatha

  1 replies

  13 years ago

  By: Alan Burstein

• Populate sql table field descriptions programatically

  I am trying to update my sql table field descriptions programatically, but I am getting an error. -…

  bryan.holmstrom

  1 replies

  13 years ago

  By: Mike John

• Column update based on expiration criteria

  I am trying to get a homegrown database to automatically update a 'IsActive' column. I have a merg…

  Erin.

  2 replies

  13 years ago

  By: Gail Shaw

• Group and Count from a table

  I have a following table and I need to group by each topic and count them. SNo Category 1 --…

  Romah

  11 replies

  13 years ago

  By: Romah

• SQL Queries for geting common values and uncommon values

  Hi...... I have one table in my database say for example "TableA" and the data is shown…

  sankar.nandakumaran

  2 replies

  13 years ago

  By: Alan Burstein

• SQL Query Help using XML

  Looking for SQL Query help on following. Have a key value pair, as below. declare @t table (id int,…

  s-sql

  2 replies

  13 years ago

  By: s-sql