Viewing 15 posts - 14,641 through 14,655 (of 15,381 total)
Also there is no need to have store these as a file on the server for the chance that somebody wants to view it. It is really quick and easy...
May 24, 2011 at 9:25 am
So do you have pdf or images stored? either way it is basically the same thing. You can pull it out of the db into a byte array. From there...
May 24, 2011 at 9:22 am
There are a few things wrong about whatever example you are referring to. The first problem is they are using the < font > tag. This is deprecated in HTML...
May 23, 2011 at 2:26 pm
SELECT CASE WHEN Fair = 1 THEN 'Fair' ELSE '' END AS Fair,
Then you should think about making a single column like Result as a tinyint where you can store...
May 23, 2011 at 10:07 am
laddu4700 (5/22/2011)
parent table column referring itself. that is why my sp is getting error nesting level exceeded (limit 32).
I have modified SP and it worked
WHERE SO2.Name = @cTableName and so1.name...
May 23, 2011 at 9:46 am
You are going to have to manually go through this list no matter how advanced your search is. You will have to do something like search where name like <list...
May 23, 2011 at 9:34 am
Ninja's_RGR'us (5/23/2011)
Why the heck was I thinking about pivot for this ?!?! Officially taking the rest of the day off 😎
Take me with you I could use it too.
May 23, 2011 at 9:31 am
If this is every row you don't the aggregate which also means you don't need to group them.
SELECT CASE WHEN Result = 'Fair' THEN 1 ELSE 0 END AS Fair,
CASE...
May 23, 2011 at 9:19 am
Let us know if you need some help getting it finished up. Glad I could help.
May 20, 2011 at 3:34 pm
There are a lot of issues with this code. I don't think I would use sql as a way to validate an email address. This could probably be a UDF...
May 20, 2011 at 3:29 pm
sql_jr (5/20/2011)
Only...
May 20, 2011 at 3:17 pm
sql_jr (5/20/2011)
Select COUNT(Tickets),
CASE WHEN DATEPART(hour,(CrDate)) between 0 AND 8 THEN 'SHIFT 1'
WHEN DATEPART(hour,(CrDate))...
May 20, 2011 at 2:42 pm
WayneS (5/20/2011)
Sean Lange (5/20/2011)
Something like this?
declare @MyString varchar(max) = '----A375475960dkgjfkfkgjfkvkl!!!!!-------DAfkdfk55500---!'
select len(@MyString) - len(replace(@MyString, 'a', ''))
Very nice Sean.
One thing to point out (for all solutions for this) is that if you...
May 20, 2011 at 1:00 pm
Hanging around here long enough has gotten me down that road a little ways too. 😛
May 20, 2011 at 12:45 pm
Viewing 15 posts - 14,641 through 14,655 (of 15,381 total)