T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Is the comparison of HashPasswords happens at the client level or db level?

  This is to follow up this thread on writing a user authentication script for a client application. …

  sleekbinary01

  5 replies

  11 years, 8 months ago

  By: x

• Need help with query

  Hi All I have a data set as given below : CodeStartDate EndDate UpdatedDate 1…

  arijit rath

  6 replies

  11 years, 8 months ago

  By: Jeff Moden

• Query help

  I have two tables. The first (tblInternalAuditRequirement) houses internal audits that are require…

  skilly2

  4 replies

  11 years, 9 months ago

  By: Eirikur Eiriksson

• compare data between 2 rows

  I have the following recordset: cmdBatchNbPdsLbsZONE 817159644 1.55320031 817159652 …

  Dominic Gagné

  4 replies

  11 years, 9 months ago

  By: Dominic Gagné

• Help for Preparing date schedule.

  Hi, I need the script for the following schedule. if the repayment start date = 05-01-2016 and inst…

  panneermca35

  7 replies

  11 years, 9 months ago

  By: panneermca35

• Remove cursor

  Hello, I currently have a process that has a cursor. It takes data and executes a stored procedure…

  djj

  5 replies

  11 years, 9 months ago

  By: djj

• Write into a table a user-entered value and increment that number n times as existing rows

  Hi, I need help deciding the best way to accomplish this. I need to have a script where it ask the …

  reliableitservice

  11 replies

  11 years, 9 months ago

  By: Jeff Moden

• Store result of stored procedure into a xml/nvarchar(max) variable

  I have a stored procedure that returns XML using FOR XML Explicit. I need to use the output of this…

  tome-473314

  7 replies

  11 years, 9 months ago

  By: MMartin1

• Create separate MS Excel files by looping through large table

  Hi I have a master table containing details of over 800000 surveys made up of approximately 400 dis…

  lenrigby

  11 replies

  11 years, 9 months ago

  By: x

• question about query

  It looked like a simple question, but I don't know how to get the answer. I need to get the user wh…

  Loner

  2 replies

  11 years, 9 months ago

  By: Loner

• Replace the column with another column when it does not exist

  I have a script that loops through a series of tables to send data to a table from each of the tabl…

  ajolson1964

  2 replies

  11 years, 9 months ago

  By: jfogel

• Dynamically Set Database

  Hello, A user is wanting to run a query against the current 3 active databases. These change every…

  SQLMan1

  9 replies

  11 years, 9 months ago

  By: Dohsan

• SSIS Question Help...

  Hi Guys, What I am trying to do, Extract the data from SQL table and Insert in Email Body and emai…

  rocky_498

  4 replies

  11 years, 9 months ago

  By: mister.magoo

• First and Last day of the month in a given date range

  Hi, I would like to get the first and last day of any month in a given date range. Ex: Display the …

  ArjunaReddy

  1 replies

  11 years, 9 months ago

  By: Dohsan

• Update records separated by group

  I have a pretty complex query that returns three records. For simplicity sake, the results can be …

  skilly2

  3 replies

  11 years, 9 months ago

  By: skilly2