Amazon messed up, that's true. However, the deal specifically states "buy one full price DVD, get one free", now every single person (with willful intent or not) did not buy...

Hi!

     "I am trying to create a process that can be plugged into any Stored Proc without modification"

I don't understand exactly what you are asking for; which of these procedures...

This is a bit long-winded and there may be a better way (you could also make this into a function) but:

DECLARE @beginDate VARCHAR(8)

DECLARE @beginTime VARCHAR(8)

DECLARE @finalDate VARCHAR(8)

DECLARE @finalTime VARCHAR(8)

SET @beginDate...

Try this instead... Amazing how a coffee at lunch can stimulate the mind!!! This version uses a table variable to store the MP3 and WAV productIDs with a label MP3, WAV,...

Scratch that..... I see now, a little rework is in order on the first part of the IF statement.... Hold on!

Hi. Confusing this one...

Can you post the DDL of the sessions table and the query you're using?

Try this and see if you get...

The line PATINDEX('%for the WAV version of this track%',@ProductDescription) > 0 checks for the part of the Product Description that states that all productIDs in the input are for WAV..

The...

Okay here goes. If I have understood this correctly:

Looking at the two examples you are going to get one of three scenarios:

1. A "for the WAV version of this track" scenario...

Hi,

You would need a VARCHAR variable to hold your concatenated string, something like:

DECLARE @concat VARCHAR(100)

DECLARE @a INT

SET @a=0

SET @concat...

I see. Thanks for the details!

Something like this should give the answer you're looking for:

SELECT COUNT(norway) + COUNT(sweden) + COUNT(finland)

FROM [north]

Hope this helps!!

Ade

Hi,

I'll try to help but I'm a bit confused as to the setup of your tables. If you could shed some light on the following it would make it easier:

You...

Hi,

I've noticed that in your table DDL you've created the iStatus column as INT but the INSERT statements have VARCHAR values for the iStatus column. If iStatus is VARCHAR the...

"Is it that women are "leaving" IT..."

In any industry sector, you will have people "leaving" to work in another sector and Newbies coming in. I think in IT, it's more...

Tuppunce from a naive 26-year-old male:

I believe that generic articles stating that 'women receive less pay than men in the male-dominated sector of IT' contribute to the lack of women...

BCP is a useful piece of kit for this, however if you are going to be exporting a number of queries instead of just the odd, adhoc ones I'd use...