Viewing 15 posts - 5,341 through 5,355 (of 8,731 total)
Brandie Tarvin (1/9/2015)
... I told them I had bought the dev edition of SQL and gotten the disk to install SSRS for free, so I played with it at home...
If...
January 9, 2015 at 2:26 pm
sonchoix (1/9/2015)
Thanks Luis and Scott for the code.Using Luis code, how do I get a total based on the 12 fields' count result?
It depends.
Are those all the possible values?
If...
January 9, 2015 at 10:24 am
If I'm correct, you just need to remove the IsValid condition and add Price column to the GROUP BY.
That should give you the desired result.
January 8, 2015 at 12:41 pm
spaghettidba (1/8/2015)
Steve Jones - SSC Editor (1/8/2015)
It's probably not that site posting SPAM, but someone with an affiliate code, or perhaps just a vandal.Maybe. Meanwhile, no response from them yet.
This...
January 8, 2015 at 12:20 pm
I'm not sure I get it. Could you post an example with ddl and sample data as you did previously?
January 8, 2015 at 11:50 am
I'm not sure where the problem can be. Basically is because the codepages change in the process. I'm not sure if it's because you're using unicode types and mixing them...
January 8, 2015 at 11:05 am
Maddave (1/8/2015)
Jeff Moden (1/8/2015)
January 8, 2015 at 10:57 am
I guess the problem is that you're reading the table 12 times instead of once.
Use cross tabs to help with your problem. More info in here: http://www.sqlservercentral.com/articles/T-SQL/63681/
This is an example,...
January 8, 2015 at 8:59 am
Consider the expertise of the employees.
There have been cases when companies decide to use Oracle because "it's better" but there's no one with enough knowledge to maintain it and tune...
January 8, 2015 at 8:52 am
As long as you have it defined in your linked servers, you can use the fully qualified name.
Server.DB.Schema.Table
If you're using QUOTENAME(), you'll need to use it for each part of...
January 8, 2015 at 8:45 am
BWFC (1/8/2015)
In VERY simple terms:
declare @tablename varchar(50) = 'YourTableName'declare @SQl Nvarchar(4000)
set @SQL =
N'select * from '+@tablename
exec(@SQL)
Careful with that, remember little Bobby Tables. http://bobby-tables.com/
A simple change can prevent that.;-)
declare @tablename...
January 8, 2015 at 8:29 am
Could you include the following parameters?
-c -C RAW
bcp Table IN FileName -T -c -C RAW -f "PhoneLog.fmt"
I'm glad that you read the questions below my name. Those questions are part...
January 7, 2015 at 6:00 pm
For previous month, according to the first result on Google, would be using the following clause.
SELECT * INTO #Wrap
FROM OPENQUERY( Shoretel_Ccir, 'SELECT e.g_event_id,wc.w_name,e.event_id,ep.agent_id,
a.a_name,et.event_name,g.g_name,e.event_time,rc.rc_name,month(e.event_time) as ''Month'',YEAR(e.event_time) as ''Year'',...
January 7, 2015 at 3:45 pm
Can you post the bcp command that you're using?
January 7, 2015 at 3:35 pm
jrodriguez 62807 (1/7/2015)
January 7, 2015 at 1:29 pm
Viewing 15 posts - 5,341 through 5,355 (of 8,731 total)