T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Sql Select query is not working on one table but the same is working on copy of the table

  Sql Select query is not working on one table but the same is working on copy of the table - I have …

  praveenkumarpalla

  8 replies

  10 years, 10 months ago

  By: ChrisM@Work

• What does 2 periods after DB name mean?

  Hi all, Normally I see db name dot field name when referring to a field in a T-SQL statement (ie Cu…

  stricknyn

  14 replies

  10 years, 10 months ago

  By: Gail Shaw

• Please help - Date Overlapping

  Hi All, I need some help in finding the overlaps in the date range using sql. below is the sample d…

  tofee498

  6 replies

  10 years, 10 months ago

  By: Dwain Camps

• SUM(CASE(DATEDIFF Calculation Problem Involving a searched CASE Expression

  I have a searched CASE expression that SUM()s two different TIMESTAMP dates ( DATEDIFF() ) and retu…

  sisterwolf_pa

  2 replies

  10 years, 10 months ago

  By: sisterwolf_pa

• Using a cursor in Sql trigger

  hi i have a trigger that will not fire due to the data coming from a bulk insert i have tried to in…

  dopydb

  12 replies

  10 years, 10 months ago

  By: MMartin1

• Left justification output

  Could I get some expert help on how to make the output of this query left justified. Its a 10 chara…

  woye1

  1 replies

  10 years, 10 months ago

  By: kaj

• Audit strategy on a separate database.

  Hello Dear Friends at the forum! I have been reading lately a number of posts regarding an audit st…

  odiseas24

  3 replies

  10 years, 10 months ago

  By: Jeff Moden

• Looping through Cursor and executing Stored Procedure. Stored procedure runs only once for one record

  The stored procedure only runs once. if I replace the running of stored procedure with select comma…

  skb 44459

  3 replies

  10 years, 11 months ago

  By: LutzM

• xp_cmdshell - Procedure expects parameter 'command_string' of type 'varchar'

  Here are the contents of @Cmd (varchar(max)): bcp "SELECT [Data] FROM myserver..dbo.PEC_Citrus_RptD…

  brosspaxedi

  10 replies

  10 years, 11 months ago

  By: brian-772889

• dynamic query

  create table dbo.dynamic(id int, name varchart) insert into dbo.dynamic(id,name) select 1,'pirana' …

  scottichrosaviakosmos

  8 replies

  10 years, 11 months ago

  By: Phil Parkin

• IF statement in WHERE

  Hi to all. I would like to modify code below to filter on a different date field based on a user se…

  2Tall

  13 replies

  10 years, 11 months ago

  By: 2Tall

• XML file data read through Stored Procedure

  Hi, We have a table that is containing the XML file data(whole xml file data). We have a requireme…

  madhusudhana.r

  3 replies

  10 years, 11 months ago

  By: gmsharma11

• Please help with Recursive CTE to get reversed people hierarchy

  I have never used CTE's before and I can't figure out how to make this work for my need. Say I have…

  Eric_Gagne

  11 replies

  11 years ago

  By: Dwain Camps

• Executing 5 procedures in one procedure

  Hi All, Can any one help me out how to execute 5 procedures in one procedure one by one …

  koti.raavi

  1 replies

  11 years ago

  By: Phil Parkin

• Update a record with a validation from other table

  Table to Update is CustomerCredit - Fields are CustomerNumber, CreditLimit Validation Table - UserA…

  skb 44459

  5 replies

  11 years ago

  By: Luis Cazares