T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Recursion in T-SQL

  I have a table XYZ with following data.. create table XYZ(parent_node_id int, child_id int) insert …

  rockstar283

  7 replies

  14 years, 8 months ago

  By: Jeff Moden

• Date period from 00:00 to 23:59

  Hi I have a script that returns a set of data that I need to send out via Reporting Services on a …

  LoosinMaMind

  7 replies

  14 years, 8 months ago

  By: LoosinMaMind

• dynamic update,insert,delete with sp???

  Puzzle: how is the insert, update, delete as Stored procedures with input parameters as a table na…

  ramsin1340

  3 replies

  14 years, 8 months ago

  By: David.Poole

• Helpl with anomaly detection

  Hi I need help writing a question that give me usernames that have logged into more than 3 differen…

  bjorn.gabrielsson

  8 replies

  14 years, 8 months ago

  By: bjorn.gabrielsson

• Insert with id of inserted row

  Hi SQL Server Central: I am building a job card application that uses 7 different tables. Using ASP…

  martintalero

  5 replies

  14 years, 8 months ago

  By: martintalero

• PK/FK on a same column, INSERT fails

  I have a column that acts as a PK and FK and when I try to insert into that column, it failes with …

  airparkroad

  20 replies

  14 years, 8 months ago

  By: tfifield

• Checking for patterns in a int

  I do not really have an example. I was wondering is there a way in Tsql to go about seeing if there…

  bopeavy

  33 replies

  14 years, 8 months ago

  By: bopeavy

• Error in SQL script

  My code fails with the error 'Must declare the scalar variable "@OldUser".' PLZ let me know what ha…

  sreedevi_c

  3 replies

  14 years, 8 months ago

  By: Jamie Ashton

• Copy from a folder to an other

  Please, Is there any transact SQL Command which allows me to copy files from one folder to another …

  abdielmomo

  21 replies

  14 years, 8 months ago

  By: Jeff Moden

• User Defined Function called from a Stored Procedure only returning a single character.

  I am calling a function to parse out a string like '7108.5W X 30D X 30H' when I debug the program t…

  RisingSunND

  2 replies

  14 years, 8 months ago

  By: RisingSunND

• Script for How many rows inserted.

  Hi, I found the excellent script at SQLfool site for capture how many rows are inserted in table on…

  SQL Galaxy

  1 replies

  14 years, 8 months ago

  By: Eralper

• A search with a Rank

  I have a bunch of duplicates within my system and I know there is an easy way to do what I need. I…

  JKSQL

  16 replies

  14 years, 8 months ago

  By: Kath Smith

• need help with the code

  Hi, I had SQL Server 2008 r2 Enterprise edition CREATE TABLE [dbo].[TableA]( [Server] [nvarchar](2…

  sql2k8

  3 replies

  14 years, 8 months ago

  By: The Dixie Flatline

• Multiple Full Joins

  Hi I have 2 tables: "Accounts" Table AccountId SecurityId Acct1 Sec1 Acct1 Sec2 Acct2 Sec3 Acct2 Se…

  deepa.devadas

  5 replies

  14 years, 8 months ago

  By: ChrisM@Work

• 2008 TSQL Upgrade Question

  So I found this link (http://technet.microsoft.com/en-us/library/cc721270(SQL.100).aspx) and have a…

  Brandie Tarvin

  5 replies

  14 years, 8 months ago

  By: spaghettidba