Viewing 15 posts - 1 through 15 (of 72 total)
Get rid of your cursor and use cross apply to iterate over provider_id,contract_id run_id etc..
December 11, 2015 at 9:41 am
Thanks Dan, Jeff for inputs. Yes, Report Model is the best option for me. Sorry if my requirement confused you. Basically, business users to whome I am going to provide...
October 4, 2009 at 9:22 am
Hi Carolyn,
you have made it really simple. awesome!!! [:)]
September 22, 2008 at 5:34 am
Thank you.
dherman (8/8/2008)
August 11, 2008 at 12:24 am
Here are some thoughts which we are planning to implement at our end...
1. Devide Application in to isolated modules which you will have by default.
2. Every View/SP created/altered...
August 8, 2008 at 12:31 am
Check out.
http://msdn.microsoft.com/en-us/library/aa173839(SQL.80).aspx
August 7, 2008 at 1:54 am
mariyappa (8/7/2008)
its throwing constant expression cannot be included...
August 7, 2008 at 1:36 am
Mark Shvarts (7/16/2008)
We have a job which runs simple select and saves aoutput to a file in flat format. Now we need to change it to comma-separated , is it...
July 16, 2008 at 8:51 pm
I don't have much time right now to think on more optimize solution on your problem, but this code should help you out.
CREATE FUNCTION dbo.match (@resume varchar(100),@keyword varchar(10))
RETURNS bit
WITH...
June 18, 2008 at 7:37 am
umaramiya (6/18/2008)
I need to find whether the keyword (@Keyword) is in the varbinary (@Resume) variable and return...
June 18, 2008 at 4:52 am
Hi James,
Here is what you need
declare @startDate datetime
set @startdate = '2008-06-13'
Select count(*) as total,
a.Numweeks
From (
select case when (round(datediff(dd, ReceivedDate, @startDate) / 7, 1)<=...
June 13, 2008 at 2:13 am
alorenzini (6/11/2008)
sqlcmd -S hqtst102D\DBA -i ListTables.SQL database="Adventureworks"
Sqlcmd: 'database=': Invalid filename.
Then I tried it like this:
sqlcmd -S hqtst102D\DBA -i ListTables.SQL -v database="Adventureworks"
and...
June 11, 2008 at 6:56 am
select right(convert(varchar,getdate(),0),7) as Format_Time
June 11, 2008 at 1:06 am
alorenzini (6/10/2008)
I am trying...
June 10, 2008 at 10:24 pm
You can have a simple PERL script for breaking file into multiple files. Create a new file everytime the number of lines read exceed 10,000 or so and then get...
June 10, 2008 at 9:59 pm
Viewing 15 posts - 1 through 15 (of 72 total)