T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• use results of view in where statement

  I have a sql server 2008 stored procedure where I want to use the results of a view in a where stat…

  wendy elizabeth

  3 replies

  12 years, 8 months ago

  By: Matt Miller (4)

• Function Vs Stored Procedure

  Hi Every one, We all Knows that we call function through select and Sp through Exec.My Question is …

  Anjan@Sql

  9 replies

  12 years, 8 months ago

  By: Erland Sommarskog

• Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. [SQLSTATE 42000] (Error 468). The step failed.

  Hi Guys, Got the following sp that I created a job to run once a day in Hosted server and the colla…

  GOODS

  2 replies

  12 years, 8 months ago

  By: Erin Ramsay

• I can't make heads nor tails of this....

  I was given this query this morning. It's not a pattern of syntax I can ever recall seeing before. …

  rray 44280

  9 replies

  12 years, 8 months ago

  By: Kurt W. Zimmerman

• Trapping error from sp in another db

  SQL Server 2008 R2 Two computers: MachineOne and MachineTwo Two instances of SQL server,: MachineOn…

  rray 44280

  5 replies

  12 years, 8 months ago

  By: rray 44280

• Help in Dynamic query....

  Hi all, I am new to this dynamic sql concept and I have written a script uaing dynamic sql but I am…

  kapil_kk

  3 replies

  12 years, 8 months ago

  By: kapil_kk

• Exclude rows

  Hey, Say I have a table with the following rows; Case | Hours | Type xxx | 3 | 1 xxx | 3 | 2 xxx | …

  lanky_doodle

  10 replies

  12 years, 8 months ago

  By: Sean Lange

• SELECT TOP ????

  Hello Everyone I am a bit curious after doing some accidental testing. I was going thru someone els…

  AndrewSQLDBA

  6 replies

  12 years, 8 months ago

  By: AndrewSQLDBA

• sum in tsql

  Hi, I have a question and see if people can help me out in this, I was trying to sum the column num…

  wei

  2 replies

  12 years, 8 months ago

  By: wei

• Add Table to Different FileGroup

  Hello Everyone I would like to create a new filegroup and add, for now, only one table, in the new …

  AndrewSQLDBA

  3 replies

  12 years, 8 months ago

  By: AndrewSQLDBA

• variable product costing

  Not sure how to explain this but here goes... I have a forecast of volume for a product for the yea…

  spin

  11 replies

  12 years, 8 months ago

  By: Sean Lange

• Query Help

  Hi I want to update Flag column in second table based on the Adder names. If the Applicatiion has a…

  DBA12345

  3 replies

  12 years, 8 months ago

  By: Sean Lange

• Reset Identity Column only on 1 Times when Month have changed

  Hi, I want to reset an Identity Column 1 Time in Month (by T-SQL -not job). How can I make sure tha…

  info 58414

  3 replies

  12 years, 8 months ago

  By: Jack Corbett

• Only functions and some extended stored procedures can be executed from within a function.

  Hi, I have this function called fn_GetTimedKey() when I run it in my SQL2005 environment it works f…

  krypto69

  2 replies

  12 years, 8 months ago

  By: kapil_kk

• DATEPART WITH YEAR AND MONTH

  Hi all how do I query datepart to include month also when passing a variable from my app. My attemp…

  jerome.morris

  1 replies

  12 years, 8 months ago

  By: ScottPletcher