T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Query help

  I need a query to get the expected output Table:Student stguid stuName…

  Mvs2k11

  10 replies

  13 years ago

  By: vinu512

• Retrieve Latest and Previous Record

  Any idea how to return the latest and previous record (TOP 2) from a table and have them on the sam…

  bpowers

  7 replies

  13 years ago

  By: Lynn Pettis

• Change case logic to boolean logic

  Hi All, I am trying to convert a case login to boolean logic, but I could not figure out one part o…

  ssc_san

  6 replies

  13 years ago

  By: ssc_san

• Need Minimally Logged Operation to Cause Checkpoint!

  I am preparing for a presentation next week and am digging for an example.... I need a minimally lo…

  dkschill

  10 replies

  13 years ago

  By: Gail Shaw

• Tracking changes to SQL Server

  I was wondering if a SQL trace could be set up to track changes to SQL Server, so I can track who i…

  dwilliscp

  4 replies

  13 years ago

  By: dwilliscp

• MSSQL, Oracle, MySQL openquery...

  Hello, My problem is that I do not know what to do from here. I am trying to find schedule conflict…

  adinica

  6 replies

  13 years ago

  By: adinica

• How to get result sets when using dynamic query

  This procedure returns ID and Question ID . I previously was sending data at application level by a…

  hafsahafeez91

  13 replies

  13 years ago

  By: hafsahafeez91

• Need urgent help

  Hi All, I have a table like this. but its have 5-6k rows. 1AppName 2AppVersion 3Product 4Date1 …

  snsingh

  3 replies

  13 years ago

  By: snsingh

• How to get all 7 days Name in One table.

  I am working on one report which showing all days name as column.but Now I am getting some bugs. If…

  zoom19

  6 replies

  13 years ago

  By: Jeff Moden

• Concatenate fields by specifying the start position of the next filed

  Hi, how do I Concatenate fields by specifying the start position of the next filed. e.g. I have tab…

  Trybbe

  2 replies

  13 years ago

  By: Trybbe

• Column name or number of supplied values?

  Hi, what is wrong in my coding? I want monitor some time interval for IO pending task witing in que…

  SQL Galaxy

  3 replies

  13 years ago

  By: SQL Galaxy

• query help

  Hi Please help for below requirement. I need to combine two columns of data and insert in new colu…

  DBA12345

  2 replies

  13 years ago

  By: DBA12345

• Diff b/w Temp tables varibles and CTE's

  Hi guys i have a doubt abut temp table and CT E's which one is faster and why,in which sceniro we …

  nareshmsbi13

  2 replies

  13 years ago

  By: j.miner

• TSQL to get users and permissions

  I would like to use the below code in a cursor and loop through each and every database in an insta…

  Pyman

  6 replies

  13 years ago

  By: Pyman

• CHAR(10) sometimes work

  IN SQL I want to print for example Ali is going to Alex so I said declare @x varchar(max) set …

  Ali.M.Habib

  2 replies

  13 years ago

  By: j.miner