Viewing 15 posts - 5,281 through 5,295 (of 15,381 total)
dwain.c (4/3/2014)
Sean Lange (4/3/2014)
Greg Edwards-268690 (4/3/2014)
it was clear they had no idea what they wanted or needed.But finish it by Friday.
This is an everyday occurrence at my job.
If it happens...
April 4, 2014 at 7:10 am
rehman-615909 (4/3/2014)
Oops, sorry Sean.
No problem. I don't mind letting Jeff have the credit...especially if I am wrong. 😉
April 3, 2014 at 2:53 pm
Revenant (4/3/2014)
Sean Lange (4/3/2014)
Greg Edwards-268690 (4/3/2014)
it was clear they had no idea what they wanted or needed.But finish it by Friday.
This is an everyday occurrence at my job.
That's OK as...
April 3, 2014 at 1:45 pm
WADRIAN68 (4/3/2014)
Firstly thanks. Secondly, the example was a simplified version of what I'm trying to do just to get the concept across, the actual tables are a better design.
The...
April 3, 2014 at 1:43 pm
rehman-615909 (4/3/2014)
Hi,Does SQL Server keeps a history of execution of stored procedures, like who executed and when? If yes, how do I access that information?
Thanks.
No it does not record that...
April 3, 2014 at 1:32 pm
Luis Cazares (4/3/2014)
Case when Status = 'Yes' then 'WithinStatus'
when Hours< Benchmark Then 'OutsideStatus'
Else 'WithinStatus'
End as...
April 3, 2014 at 1:31 pm
Greg Edwards-268690 (4/3/2014)
it was clear they had no idea what they wanted or needed.But finish it by Friday.
This is an everyday occurrence at my job.
April 3, 2014 at 1:23 pm
SQL Guy 1 (4/3/2014)
How many columns do you have to alter?
Totally 9 columns:
7 : Nvarchar --> varchar
2 : text --> varchar
Ouch. Not sure what your table looks like but...
April 3, 2014 at 1:22 pm
Stubby Bunny (4/3/2014)
Sean,thanks for the link to applys, wish I had know about these before could have saved me a lot of headaches. thank you
You are quite welcome. Just...
April 3, 2014 at 1:03 pm
Stubby Bunny (4/3/2014)
April 3, 2014 at 12:53 pm
SQL Guy 1 (4/3/2014)
Sean Lange (4/3/2014)
The proper syntax is quite simple.
ALTER TABLE t1
ALTER COLUMN c1 INT;
ALTER TABLE t1
ALTER COLUMN c2 varchar(10);
I am just doing this way - separate ALTER...
April 3, 2014 at 12:52 pm
I would probably use APPLY similar to Lynn but here is another approach that should accomplish the same thing.
Select a.intPersId
,mn.strFullname Name
,a.strSignature
,CONVERT(Varchar(10), a.dtSigned, 111) dtSigned
,CONVERT(Varchar(10), a.dtnotified, 111) dtNotified
,CASE WHEN a.dtSigned IS...
April 3, 2014 at 12:49 pm
My first question is why are you using a subquery here? This is just another left join.
Select distinct a.intPersId
,mn.strFullname Name
,a.strSignature
,CONVERT(Varchar(10), a.dtSigned, 111) dtSigned
,CONVERT(Varchar(10), a.dtnotified, 111) dtNotified
,CASE WHEN a.dtSigned IS NOT...
April 3, 2014 at 12:26 pm
The proper syntax is quite simple.
ALTER TABLE t1
ALTER COLUMN c1 INT;
ALTER TABLE t1
ALTER COLUMN c2 varchar(10);
April 3, 2014 at 12:21 pm
If you stick with the loop you might consider that the code inside will never execute...
Declare IntFlag (int)
Set IntFlag = 0
While IntFlag <> 0
April 3, 2014 at 12:13 pm
Viewing 15 posts - 5,281 through 5,295 (of 15,381 total)