T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Getting DATEPART of getdate()

  Hi I am trying to extract just the hours and minutes form getdate. The best I have come up with i…

  Kwisatz78

  4 replies

  14 years, 9 months ago

  By: Kwisatz78

• Unexpected results; SELECT statement with IN and NOT IN

  This is puzzling...at least to me. SELECT A FROM TABLE 1 WHERE A NOT IN ( SELECT Field1 FROM B ) AN…

  Chrissy321

  2 replies

  14 years, 9 months ago

  By: yubo1

• need a query to join two or more tables with left out join

  Hello All experts, I have requirment to run the queries against three tables with left outer join, …

  rashid_alavi

  3 replies

  14 years, 9 months ago

  By: rashid_alavi

• Same statement, sometimes executed as SQL batch, sometimes as RPC

  Hi all, I have a TSQL case I cannot explain. The problem is that the same SQL statement from the sa…

  sasana

  6 replies

  14 years, 9 months ago

  By: sasana

• Query - Database

  I know I can get the information from sys.master_files and sp_heldb but how can I write a query to …

  The_SQL_DBA

  3 replies

  14 years, 9 months ago

  By: svas_chowdary

• Same Table Twice

  Hi All, I have 4 tables, Employee: Id, code, name, pos_def_id 213, Z300, Diana Benk, 108 ShiftAssig…

  ringovski

  4 replies

  14 years, 9 months ago

  By: SQLRNNR

• SQL Insert Data from one table to other table

  Hi All, I'm having two databases, I need to run a query in my aspx pageload that checks for any new…

  User7766

  8 replies

  14 years, 9 months ago

  By: ColdCoffee

• stored procedure and pass through

  I have a pass through query that is like: execute spsocialcount '[BeginDate]','[EndDAte]','[Holiday…

  bill.akin

  7 replies

  14 years, 9 months ago

  By: bill.akin

• Compare varchar to decimal

  DDL & sample test data: create table #TEST ( idint, totdaysvarchar(6) ); GO INSERT TTEST …

  Sqlraider

  4 replies

  14 years, 9 months ago

  By: Sqlraider

• Need a query

  I am showing you dummy data select A,B,C from TEST Output: 1011 1012 1121 1122 1131 113…

  kishoremania

  2 replies

  14 years, 9 months ago

  By: kishoremania

• TSQL Quotes Within Quotes

  Can anyone spot what is wrong with this? EXEC [LinkedServerName].master.sys.sp_executesql 'BACKUP D…

  hindle.steve

  4 replies

  14 years, 9 months ago

  By: venoym

• Heap table taking up 4 dpages per row?

  I have a problem with a heap table that has a single index (not clustered). For reasons that are no…

  pcd.1

  3 replies

  14 years, 9 months ago

  By: pcd.1

• XML EXPLICIT ISSUE IN SP

  Hi All, I wanted the resulted xml to look like this : <Root> <QueryWaiting version="B000"&…

  rams.prsk

  1 replies

  14 years, 9 months ago

  By: Gail Shaw

• How to get output in following formats

  I writing a query as follow Select 'I87' [Location],PC.Company_Name [Company Name], Q.Department…

  amitsingh308

  4 replies

  14 years, 9 months ago

  By: mr_opto

• Issue with the collation

  Hi I have a requirement where i need to take the database default collation for creating the view. …

  parsi_divya

  2 replies

  14 years, 9 months ago

  By: parsi_divya