T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Alternate to context based search

  Hi, I have a proc like this: CREATE PROCEDURE GetSearchText @Filter VARCHAR (50), @Context VARCHAR …

  Sathishk

  7 replies

  14 years, 2 months ago

  By: Chuck Hoffman-291200

• Enumerate single row to multiple rows

  I am having a table A with two columns RoomID and BedCount. The purpose of the application is to al…

  logicwonder

  3 replies

  14 years, 2 months ago

  By: logicwonder

• Group Current and Previous Month of 22-Work-Day-Dates By a "Group Number"

  I need to group together each work-day date for both the current month and the previous month. Furt…

  Scott Solice

  12 replies

  14 years, 2 months ago

  By: Scott Solice

• Transaction Count after Execute error

  I'm trying to troubleshoot a stored procedure error and not having much luck so far. I have a proce…

  Jason Whitish

  7 replies

  14 years, 2 months ago

  By: Orlando Colamatteo

• Getting the Distinct group of records in one single record

  In my below query, if the data from the 1st column (DepartureTime) up-to-the 2nd last column (Valid…

  sbj1411

  11 replies

  14 years, 2 months ago

  By: sbj1411

• Shifting values to the left

  Hi, does anyone know of an easy/direct way of doing this? I have three address fields: addr1, addr2…

  Mike Scalise

  17 replies

  14 years, 2 months ago

  By: drew.allen

• Changing Job step properties

  Hi, I've been looking for help changing SQLAgent job step properties. Specifically I keep all my SS…

  scribesjeff

  3 replies

  14 years, 2 months ago

  By: Suresh B.

• Item Stock Update problem (Set Based solution)

  Hi, I need help in resolving this issue. I have the following tables (Some comments are there to un…

  jewel.sacred

  21 replies

  14 years, 2 months ago

  By: sturner

• Memory Utilization

  Hello, During some operation I want to check the Memory utilization. Can I get some memory utilizat…

  sqlnaive

  5 replies

  14 years, 2 months ago

  By: TheSQLGuru

• join -- The amount of the most recent child record

  Here's a type of query that has always puzzled me, in fact, I've even asked SQL gurus about it. In …

  Half Bubble

  5 replies

  14 years, 2 months ago

  By: Jeff Moden

• Need to Filter Query by Schema

  I need to Need to filter the following Query by Schema: IF EXISTS ( SELECT * FROM tempdb.dbo.s…

  Welsh Corgi

  7 replies

  14 years, 2 months ago

  By: Welsh Corgi

• Try to enclose ' within SQL Output

  I'm trying to get the following output from the SQL Statement listed below, however I forgot how to…

  Welsh Corgi

  5 replies

  14 years, 2 months ago

  By: Jeff Moden

• a looping subquery whose result set is used by parent? do I use a CTE?

  I need to write a query that returns a list of students and their *final* grade. The table I'm que…

  xenophilia

  27 replies

  14 years, 2 months ago

  By: xenophilia

• OUTPUT CLAUSE replaced --when not matched by source then delete; WITH Update

  I was handed off some code did not do what the customer needed. I'm tracking the Number of Inserts …

  Welsh Corgi

  10 replies

  14 years, 2 months ago

  By: Lynn Pettis

• Help with an IF ELSE statement

  Hi I am writing some code to calculate an end SLA expiry date for any given period. How it works is…

  _Beetlejuice

  5 replies

  14 years, 2 months ago

  By: drew.allen