If you have 1,000 users firing off INSERT statements in a...

mxy (6/24/2015)

---

thanks for ur response. if thousand records fire at a time it would cause blocking or does it cause triggers to fail.

2) what would you suggest a sql job...

Please test the following, as it at least appears to work on the sample data from a previous post:

DECLARE @StoreHours AS TABLE (

StoreID int,

MonOpen varchar(10),

MonClose varchar(10),

TueOpen varchar(10),

TueClose varchar(10),

WedOpen varchar(10),

WedClose varchar(10),

ThuOpen...

Okay. Post the data in consumable INSERT statements and provide the table create statements and include the business identifier column, and I'll take a shot at it. ...

I hope you're not using this data structure as the basis for accounting data. There is way too much other maintenance that would get very tricky after any...

blarson 11072 (6/24/2015)

---

I have a data file listing open and close hours for the day of the week. I need to format it like

Mon-Thurs 7:00 AM - 5:00 PM

Fri...

mxy (6/23/2015)

---

hello,

i am setting up a process for the dataload, external windows service insert a record to dbo.dataload table with a status as 'Ready'

create table dbo.dataload

(Xmlcol xml

,Loadstatus varchar(15)

,Starttime datetime

,completedtime datetime)

now...

Unfortunately, MS SQL's PIVOT only operates on one field, and what you're looking for isn't really a PIVOT operation. What you need is a concatenation function that can...

If you can find out approximately when the data record was added, you might be able...

g5808599 (6/24/2015)

---

i don't update. It remains 1.

This is the original exam that i translate

The report contains Friend couples in SN. The report contains GradoOfRelationship, for a given pair of people,...

ChrisM@Work (6/24/2015)

---

samartel (6/24/2015)

---

Quick one for you all. I dont have access to test this or I would but I know you all are quick to help a brother out.

I...

SQL-DBA-01 (6/23/2015)

---

Hi Experts,

While trying to change date format from INT to datetime getting the error.

Is this not possible to change "last_occurrence_date" from INT to Varchar?

select name, delay_between_responses, occurrence_count,

CAST(CAST(last_occurrence_date...

g5808599 (6/24/2015)

---

i know that it can be an horrible situation but i need to learn how to do this thing with trigger ;(

if you can help me also it is...

Yep, sure does... There are no really good, readily available, solutions for a problem of this nature. It takes the resources...

g5808599 (6/24/2015)

---

before thanks for your answer. It's not infinite they can not be exist something like this (Two rows with the same friends but with a different GradeOfRelationship)

Luc Marc ...