T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• FOR XML EXPLICIT - newie question

  Hi, I'm new to XML EXPLICIT. I need a parent tag around the second SELECT. I added a simple example…

  Teutales01

  1 replies

  13 years ago

  By: Teutales01

• start sql agent 2005 with t sql

  hello , i have a job which start every one minute , i want to before my job start verify with t sq…

  eboucicaut

  1 replies

  13 years, 1 month ago

  By: Orlando Colamatteo

• Recursive Query

  Hi All, Thanks in advance for those who will contribute. I have a recordset of the following PlanAc…

  Catcha

  10 replies

  13 years, 1 month ago

  By: Dwain Camps

• Get the NON NULL and NULL values in a single query

  HI, DECLARE @ID INT SET @ID = NULL DECLARE @TABLE TABLE(fldID INT) INSERT INTO @TABLE SELECT 1 UNIO…

  sqlusers

  9 replies

  13 years, 1 month ago

  By: adrian.facio

• removing brakets from data in select

  Hi I have a table showing data inside brackets, I want to remove the brakets and just keep the data…

  sql_learner29

  3 replies

  13 years, 1 month ago

  By: Sean Lange

• "Variable" for switching Table Names

  I have a MS NAV database where company data for each company has separate tables in a single databa…

  battery_acid_h

  6 replies

  13 years, 1 month ago

  By: Eugene Elutin

• adding rownumbers in a continuous fashion to returned rows

  Hi, I have a result set that identifies the employee info in each row...like this: StartDocument PE…

  sql_learner29

  14 replies

  13 years, 1 month ago

  By: sql_learner29

• Pivot would help me

  Doing crosstabulation with the PIVOT operator would be very helpful for me, but this simple query…

  Phunhog

  2 replies

  13 years, 1 month ago

  By: Phunhog

• How does one force a column (which is not the PK) to be unique?

  I have a table with only two fields (columns). strInitials - nvarchar(3) Emp_No - int - Primary Key…

  Ken at work

  7 replies

  13 years, 1 month ago

  By: Ken at work

• Calculate Age and Elapsed Time

  [font="Arial"]Hello All, There may be millions of way calculating age to get years,months,days,H…

  praneshram

  7 replies

  13 years, 1 month ago

  By: Dwain Camps

• IF exists Question

  I need to update an item table(item_tbl1 ) but only if the item number is in item_tbl2 and not alre…

  twdavis-893252

  7 replies

  13 years, 1 month ago

  By: Dwain Camps

• CTE Usage

  Why does the usage of a CTE give these errors ? Msg 156, Level 15, State 1, Line 3 Incorrect syntax…

  Carl Federl

  12 replies

  13 years, 1 month ago

  By: Dwain Camps

• Trying to dynamically update operators

  /*This updates the on call operator*/DECLARE @onCall varchar(20), @offCall varchar(20),@onCallPage…

  jshurak

  2 replies

  13 years, 1 month ago

  By: jshurak

• Unclosed quotation mark after the character string

  It sounds like a simple error with an obvious fix but its not. The sql that caused the error 'Unclo…

  sdruid71

  1 replies

  13 years, 1 month ago

  By: Lowell

• Problem in passing of parameters in a stored procedure. Please help.

  Dear SQLCentral.com members and administrators, Hello guys, a greeting of peace. It is my first tim…

  marksquall

  25 replies

  13 years, 1 month ago

  By: mtassin