Lynn Pettis (4/24/2015)

---

jonathan.crawford (4/24/2015)

---

Steve, my brother is getting hitched on the 4th of July weekend in Breckinridge. I'm not sure we're going to be able to make it, but assuming...

I would disagree...

SQLRNNR (4/23/2015)

---

If only we could get the adults to get off their...

Did the presentation this morning. I started by making sure this is the "new hire orientation" and that everybody was ready to get some information on their first day of...

They are pretty slick. I was working on an article to explain how to use them both...

Excellent question. I got it right by deduction more than understanding. I figured the scalar would run for each row but I would have thought the itvf would too...but then...

Not that I care which style you prefer but the code I posted returns the exact same results. 😀

tlp6327 (4/22/2015)

---

I have got 4 MS Access Database Files, which have got 3 Tables each, means Total 12 Tables which gets updated with new data every evening, by an external...

ldummer (4/22/2015)

---

I have a table that holds Folders and the documents with a version number. What I am trying to do is list the folder, distinct documents and the...

ajspencer (4/22/2015)

---

Hollo,

I am in need of some coding help..... I'm trying to transpose rows to columns at the same time do a count of the rows without getting duplicate crs_id.

select...

Sam Garth (4/22/2015)

---

Hi

I have been looking at a SQL agent job that runs.

The issue is that it joins a lot of tables as well as a lot of views. If...

It is hard to know exactly what you need here. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample...

dwain.c (4/21/2015)

---

WITH Alphas AS

(

SELECT a

FROM (VALUES('A'),('B'),('C'),('D')) a (a) -- use 22 letters

),

Numbers AS

(

SELECT...

serg-52 (4/21/2015)

---

May be something like

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tsample]') AND type in (N'U'))

DROP TABLE [dbo].[tsample]

GO

create table tsample (

id int identity(1,1)

,val varchar(8000));

insert tsample...

I am a bit scared that you...