Koen Verbeeck (4/15/2014)

---

shafirmubarak (4/15/2014)

---

Thanks for your quick response.

I would like to import as it is. I dont want to ignore the rows which has null GUID.

It's acutally child records which...

what exactly you want to do with GUID column having null value?

Want to keep in the original table?

OR

want to Ignore this data

OR

Want to place a new GUID?

good question Steve. Thanks for sharing

In addition to Free_Moscot

there the three part series from Perry Whittle

SQL Server 2012 AlwaysOn Groups and FCIs Part 1[/url]

SQL Server 2012 AlwaysOn Groups and FCIs Part...

Thanks lrasner, your question have just awakened me 😀

Excellent QotD, Thanks for sharing

nice Lynn 🙂

Hugo Kornelis (4/10/2014)

---

Just for the record - GO is not a statement, it is a batch separator. It will be intercepted and handled by the client. Send a "GO" to...

What exactly you...

try this

Declare @start_dte as datetime = '01-Apr-2014'

, @end_dte as datetime = '30-Apr-2014'

Declare @WeekDayTable Table ( colWeekDayID tinyint

, ColWeekDayName varchar(20)

, ColIsWeekEnd bit

)

Declare @HolidayTable Table...

All you need to is to unpivot your table 1st.

then use the logic which been shared earlier.

To unpivot you can do this

;With cLuke_PS2

AS

(

SELECT [Ward or Team Name], [Date],...

i caught two points 😛

This is Link[/url]

Koen Verbeeck (4/8/2014)

---

Interesting question.

Always nice to see how Microsoft differs from other vendors (or how other vendors differ from Microsoft :-D) when it comes to terminating a simple line.

Always nice...

Something like this

Declare @RemoveNumeric as varchar(30) = '12112this is what i want'

Declare @n table ( number int )

insert into @n

Select top 10 ROW_NUMBER() Over ( ORder by object_id) -...

All i have understand is this, Description Field contains ETL Data.

If users want to change data , then Application is shows edited data Otherwise ETL data.

your actual question would...