Luis Cazares

Forum Replies Created

Viewing 15 posts - 8,371 through 8,385 (of 8,731 total)

RE: split string into columns based on special character

You could use Jeff Moden (& the community) Splitter[/url]
Along with Cross Tabs[/url]
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

September 21, 2012 at 2:41 pm

#1540975
RE: Decimal to DateTime2 conversion SQL SERVER 2008 help

There's not enough information on your post to give you a real answer.
We can't see your data.
However, I would recommend you to examine this:
select
CONVERT(varchar(30),clx.prdt) as ADate
from EXPM clx where...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

September 21, 2012 at 2:30 pm

#1540968
RE: The SQL Saturday Thread

Anyone is going to SQL Saturday 151 in Orlando?
I would like to meet some of the people from SSC.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

September 21, 2012 at 1:51 pm

#1540952
RE: Design pattern for Phone

Chad Crawford (9/21/2012)
Luis Cazares (9/21/2012)
Chad Crawford (9/21/2012)
For our app we are going to go with a generic "Phone 1", "Phone 2", etc. up to a "Phone 7" and...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

September 21, 2012 at 12:21 pm

#1540893
RE: Design pattern for Phone

Chad Crawford (9/21/2012)
For our app we are going to go with a generic "Phone 1", "Phone 2", etc. up to a "Phone 7" and store each in it's own...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

September 21, 2012 at 11:39 am

#1540875
RE: Creating Trigger To Update Total On 'Parent' Table

CELKO (9/21/2012)
You have several fundamental errors.
Let's begin:
1. Tables model sets so their names are plural or (better) collective nouns. See ISO-11179 or any book on data modelign.
Agree, that's a...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

September 21, 2012 at 10:42 am

#1540854
RE: correct syntax for a nested select statement using the SUM function

It's hard to understand what you're trying to do, I hope that you can help us to help you.
As Sean said, SUM() will only allow one parameter.
I've made some changes...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

September 21, 2012 at 9:37 am

#1540811
RE: Jacksonville Code Camp 2012

It would have been great to understand the difference between row-by-row programming and set based programming (or procedural language and declarative language). It would be important to notice when is...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

September 21, 2012 at 8:52 am

#1540756
RE: T-SQL Help Needed

SomewhereSomehow (9/20/2012)
p.s.
(But who cares my opinion=))
All the opinions are valuable, either if they're correct or not, as everything is an opportunity to learn.
Regarding the beating, there's something in Wikipedia about...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

September 20, 2012 at 2:40 pm

#1540389
RE: T-SQL Help Needed

Lynn Pettis (9/20/2012)
SomewhereSomehow (9/20/2012)
CELKO (9/20/2012)
don't think you'll scare him. Maybe offend, but not scare. He comes across as one of those borderline sociopathy cases that have very thin skin,...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

September 20, 2012 at 1:22 pm

#1540342
RE: Ever feel your boss is expecting you to make a house out of sand?

Maybe this can inspire you 😉
Gallery
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

September 20, 2012 at 11:22 am

#1540268
RE: End Of Year

Eugene Elutin (9/20/2012)
Luis Cazares (9/20/2012)
Eugene Elutin (9/20/2012)
jcrawf02 (9/20/2012)
Eugene Elutin (9/19/2012)
Jeff Moden (9/18/2012)
Eugene Elutin (9/18/2012)
Please ignore this stupid remark!
Easy, big guy. You're right but that's something that he would say....
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

September 20, 2012 at 11:11 am

#1540259
RE: Northwind Database for SQL Server 2005

The instructions are mostly generic as VS 2012 is independent of SQL Server.
You can follow the instructions here: http://www.codeproject.com/Articles/20987/HowTo-Install-the-Northwind-and-Pubs-Sample-Databa if you don't feel confident to use the SQL Script files...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

September 20, 2012 at 11:01 am

#1540251
RE: help with a query

My opinion has nothing to do with my capabilities.
At the time, I don't have any work to do, so I treated this as a challenge for me. Others might not...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

September 20, 2012 at 10:07 am

#1540208
RE: help with a query

At this moment, I wish I didn't post any response.
Your answers have been rude to someone that is trying to help you by giving a good advise.
This might cause others...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

September 20, 2012 at 9:15 am

#1540156

Viewing 15 posts - 8,371 through 8,385 (of 8,731 total)