T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Help with query joining same table top 1

  following query works SELECT matltran.trans_num, matltran.trans_type, matltran.trans_date, matltran…

  skb 44459

  3 replies

  11 years, 9 months ago

  By: Sean Lange

• Repeat dataset by integer value in another table.

  I have a report that prints a manifest which is loaded onto n number of pallets. I have a lookup fo…

  Kelvin Phayre

  3 replies

  11 years, 9 months ago

  By: ChrisM@Work

• How to create a repeatable +ve integer from a nvarchar?

  Hi, I need to create an id from a nvarchar value that is repeatable, sort of like a checksum or a …

  sarah.cook

  4 replies

  11 years, 9 months ago

  By: sarah.cook

• SELECT * FROM master.sys.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher' not returning any results though SQL Server Agent is running

  Hi, SELECT * FROM master.sys.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher' is g…

  Sakthivel Chidambaram

  11 replies

  11 years, 9 months ago

  By: TheRedneckDBA

• convert vb code to t-sql (pdf automation)

  Want to convert VB Code to SQL Dim objMyForm objMyForm = CreateObject("CutePDF.Docu…

  skb 44459

  12 replies

  11 years, 9 months ago

  By: Sean Lange

• Fill Adobe pdf form using t-sql

  Is there a way to fill the adobe pdf form with sql data using t-sql and save it ? I can install ful…

  skb 44459

  1 replies

  11 years, 9 months ago

  By: Phil Parkin

• How to suppress SELECT returned messages

  I have a SELECT statement (using and OPENQUERY and a Linked Server) that if the tablename is not fo…

  bgrossnickle

  3 replies

  11 years, 9 months ago

  By: bgrossnickle

• SELECT with a variable Tablename

  I am rying to run a TSQL SELECT Count(*) that has a @Tablename variable in it. My Tablename name n…

  bgrossnickle

  7 replies

  11 years, 9 months ago

  By: Dwain Camps

• T-SQL Function that works like the FIRST funcion in MS Access?

  Hello, I need to convert a query in MS Access to a view in SQL Server 2005. The view will draw from…

  jamesheslin123

  14 replies

  11 years, 9 months ago

  By: jamesheslin123

• Referential Integrity - how to avoid errors so I can automate manual process - vendor code

  Hello I work at a place with many non-technical project managers and an external vendor. Each week …

  NJDave

  2 replies

  11 years, 9 months ago

  By: NJDave

• tsql query for counting a 'grouped by' and a where clause

  Can anyone help with this please? I am trying to count all users in a table who are superusers (onl…

  mrichardson 57577

  8 replies

  11 years, 9 months ago

  By: mrichardson 57577

• How to find the 2nd Monday following a given date.

  Can someone help me figure this problem out? Thanks

  fstop

  9 replies

  11 years, 9 months ago

  By: SwePeso

• Reg: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

  Hi, I am new to this DB Development. Please advice, why we need this "SET TRANSACTION ISOLATION LEV…

  nagesh.prasad

  10 replies

  11 years, 9 months ago

  By: Sean Pearce

• SQL Query

  Dear members I have a query below; use DBMUST select [dbo].[tbl_VOUCHER_CAPTURE].dt_VOUCHER_ISSUE_D…

  sundayose

  2 replies

  11 years, 9 months ago

  By: Jeff Moden

• Tsql to create columns from comma separated values

  Hi All, I have table with single column (Datatype: nvarchar(4000)) and with following records: 1,2,…

  sam 55243

  2 replies

  11 years, 9 months ago

  By: sam 55243