T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Query Help selecting from Multiple Tables

  I have 3 Tables, one for Company, one for Contact and one for Phone Numbers. Each Company can have…

  BLombardi

  2 replies

  12 years, 4 months ago

  By: Dwain Camps

• Question about case then and where with parameter

  Hello Experts, I have the following querie using case then statement for one of my fields as it fol…

  montse 22199

  2 replies

  12 years, 4 months ago

  By: montse 22199

• Getting Child-Top Level Parent Relationship without looping

  Hey all, Given the following: CREATE TABLE #Transfer ( ID INT IDENTITY PRIMARY KEY, OldKey INT, …

  kramaswamy

  2 replies

  12 years, 4 months ago

  By: kramaswamy

• Can I Provide SP to 3rd Party without tell them DB name

  I assigned to prepare SP API for vendor, but I concern about script and DB security. I have to prov…

  wertyui

  1 replies

  12 years, 4 months ago

  By: Adi Cohn-120898

• plz i need help!!!!

  i want the entry for adding 2 value but i want show in the third cloumn all result with null value!…

  almany_13

  11 replies

  12 years, 4 months ago

  By: Mahmood.BilalB

• How to Get Instance Name from T-SQL

  Hi All, How to get Current Instance Name of SQL Server from T-SQL (i.e. from Query window)?…

  Arun-644923

  14 replies

  12 years, 4 months ago

  By: Armando V.

• Getting recent 100 Records with filter on date range

  Hello, We have one complex procedure which returns top 100 recent records ,it was taking too much …

  Megha P

  1 replies

  12 years, 4 months ago

  By: Dwain Camps

• on delete trigger

  Hi, I have to write a trigger on my table to prevent data delete and also to log what is tried to …

  thbaig

  4 replies

  12 years, 4 months ago

  By: Eugene Elutin

• Is sp_executesql with parameters completely safe?

  Just wondering, if I construct a SQL query in a Stored Proc, and pass record selection criteria int…

  a648

  2 replies

  12 years, 5 months ago

  By: a648

• Check for existence of a single value for all rows in a column

  I'm trying to come up with a fairly simple way to query three different columns in one table such t…

  jhager

  6 replies

  12 years, 5 months ago

  By: ChrisM@Work

• XML question

  Hello, I am working on a project that requires XML in a format that I have not worked with before. …

  oradbguru

  2 replies

  12 years, 5 months ago

  By: oradbguru

• Delete specific node from XML column

  TABLE tblProduct ProductId int Productname varchar(20) TABLE tblQuantityP QuantityPId Quantity int …

  thbaig

  1 replies

  12 years, 5 months ago

  By: Bhuvnesh

• A case statement in the from clause?

  I need some help with a query that involves changing the joins when a field is a certain value. Th…

  Pirate92

  1 replies

  12 years, 5 months ago

  By: mtassin

• Rows with Min() values

  Hi All Can someone help me how to select the row with min(E_DATE+E_Time) for each PATIID from the b…

  popq79 34287

  5 replies

  12 years, 5 months ago

  By: Sean Lange

• Need a Stored procedure

  Hello, I need help writing a stored procedure that will take a parameter in as @hostName VARCHAR(10…

  oradbguru

  7 replies

  12 years, 5 months ago

  By: Orlando Colamatteo