Hi

Thanks for the article. A really good read and will help me focus on what I need to cover for the exams.

I did a search on the entire table and yes there are a few records right at the top that dont include the 'for_' string. And both scripts do work...

Thanks for trying.

I thought someone else might have had the same problem. I ran the scripts at the same time and the data in the tables doesnt change often. The...

How much of SQL do you know? Have you studied SQL before? Anything...

Hi

I have no sample data to work with but maybe this will help you...

declare @UserDate datetime

;with cteMain AS (select * from Employees where datepart(yy, CheckDate) = datepart(yy,@UserDate)),

cteYTD as (select...

Oh and 1 more thing....

If I leave out the column

convert(nvarchar(10),imp_date_created,103) as 'Import Date'

both scripts run fine.

Its only once I added in this column that I had the error. After...

Thanks for that but I've had that error before.

I would have thought that would be the case. If it were, wouldnt the second script not run as well?

As...

Thanks.

I just had a look at pivots and I see that for Pivots you would have to know the column names beforehand - the same as for case statements, so...

Thanks David.

Didnt see your reply there as I was typing out mine. The guys here on SQL ServerCentral reply really quick:smooooth:

Ahem.....

Just did some investigating....:blink:

declare @a varchar(10)

set @a = 'abcd a_b'

select charindex('cd', @a) ...

An alternative would be to use

declare @a varchar(10)

set @a = 'abcd...

Arjun Sivadasan (3/11/2011)

---

To make text appear as quoted, enclose the text in '

' beginning tag and end tag.

Alternatively, select the text in the editor and click on quote IFCode shorcut....

The date in the two fields are different, I want to insert the Date column along with all other entries into the temporary table #temp .I want all the dates...

Hi

You can select both dates as follows:

INSERT INTO #temp

...

Hi

What column are you trying to update and what value do you want to set it to? Is the new value a simple calculation of whats already there or will...