T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• convert multiple rows in single column

  Hi All, Scenario is like that single dept can have multiple LocationHeads, If Location heads are mu…

  abhas

  2 replies

  11 years, 6 months ago

  By: abhas

• Understanding Joins !!!

  Hi all expert, I am having some problem understanding joins (Specially left,right and outer apply)w…

  JackTimber

  5 replies

  11 years, 6 months ago

  By: keranpc

• Trigger or Not Trigger

  Hi to all, I have a question, I think all expert DBA can give me detailed answer on this one. Is it…

  Teemo

  18 replies

  11 years, 6 months ago

  By: Jeff Moden

• Return single row for matching columns based on 3rd column

  I have data: Ticket User Priority A ME 1 B ME 1 C M…

  jamie_collins

  5 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson

• Error Single quote stored in variable

  I'm trying to create a Character string so that I can execute dynamic SQL. The date is going to cha…

  Welsh Corgi

  37 replies

  11 years, 6 months ago

  By: Welsh Corgi

• Programmatically generate a number sequence

  Hi all -- hopefully, this is a simple question. I'm trying to do a simple insert into a table, some…

  Ray K

  9 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson

• BCP queryout returns no records?

  I have a SP that manipulates data for picking products and puts them into a temp table "#PickList" …

  mmcardle

  1 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson

• Get the rows based on the current quarter

  Hi Guys, Sorry first of all posting the query in wrong, but I hope I will hope some answers. I am w…

  Smash125

  4 replies

  11 years, 6 months ago

  By: J Livingston SQL

• TSQL to create Excel 2013 file

  Hi Everyone, The company I work in was using sp_makewebtask for creating an excel file, but since …

  vinu512

  21 replies

  11 years, 6 months ago

  By: Umer Akram

• merge data dynamically?

  Hi all, I'm curious if something like this is possible in SQL Server 2008: I have table of standar…

  jeff.born

  1 replies

  11 years, 6 months ago

  By: Dwain Camps

• How do I write this code?

  Can't seem to figure this one out, although it seems like it should be rather simple. I really app…

  rrdavis07

  8 replies

  11 years, 6 months ago

  By: Dwain Camps

• Error: Declare scalar variable @oobe_oem_config

  Hi guys, I am facing an issue with the below query. I am not sure what's wrong as I have already de…

  Feivel

  1 replies

  11 years, 6 months ago

  By: Adi Cohn-120898

• Help with Query Pull Thursday to Wednesday

  Thank you all in advance to new blogger and SQL user, I've been task to pull daily report that cove…

  ajmoon1313

  6 replies

  11 years, 6 months ago

  By: ajmoon1313

• Question realetd to TABLOCK

  I have asked a question related to Nolock separetely. Here is a question related to tablock. I am t…

  itskanchanhere

  4 replies

  11 years, 6 months ago

  By: pooyan_pdm

• Query into text file: bcp, dynamic SQL, temp tables and table variables

  I am adding a section to some vendor code to create a text file from data in a temp table and send …

  mmcardle

  2 replies

  11 years, 6 months ago

  By: mmcardle