You have to use DECLARE statement in order to declare a variable. I tried this

DECLARE @PVC_APPLICATION_NAME VARCHAR(50)

SET @PVC_APPLICATION_NAME='APPLICATION NAME1 '

PRINT @PVC_APPLICATION_NAME

and it showed me as result: "APPLICATION...

Nice question, thanks.

Here is also a discussion on this topic: http://social.msdn.microsoft.com/Forums/en-US/sqlservicebroker/thread/eca47504-9a8c-4c0f-a4a4-3a56fb5a012b

Hi Aaron,

I reached when the meeting has already finished. Is there any way I can see a record?

Thanks a lot,

Iulian

The number of the weekend days in the first 4 days of the month can be determined using datepart function, something like this: CASE WHEN DATEPART( WEEKDAY, GETDATE()) BETWEEN...

Here you will need to determine and add the numbers of weekend days.

and the code will be

4 + [weekend days in the first 4 days of the month]

Regards,

Iulian

In order to have working days you will need to create a calendar like in this article

Fun with business days, calendar tables, and test-driven development - By Alex Kuznetsov,...

Nice question, thanks.

Here is an article about the subject also: Instant File Initialization Speeds SQL Server

Iulian

Great idea!

Using a buffer for data validation before import.

Thanks,

Iulian

Hi,

Reading this article it does not look very practical to me, but this depends on your needs.

Here is a step by step guide on how to do it on...

I understand: so it makes admin's life easier, I guess you can even schedule it to empty huge tables very easy and fast then load them with new and...

Thank you Kingston and Drew,

you are right in SQL Server there are datetime data types with functions designed for this kind if data. yyyymmdd as int would not make...

What about storing data as int like this yyyymmdd? (year*10000 + month*100 + day)

The pros are:

the numerical order is the same as calendar...

Good question, well done!

as Kingston wrote earlier, per BOL looks like there are a few more restrictions on truncate,

You cannot use TRUNCATE TABLE on tables that:

* Are referenced...

Thank you Alvin, your remark together with the link from wildt about

Populating a Kimball Date Dimension

are what I am looking for.

Very nice article Alex, thank you.

Indeed IsBusinessDate 'Y' or 'N' is great for building an understanding of the concepts, I remember when I implemented this functionality using something similar;...