Viewing 15 posts - 1 through 15 (of 131 total)
You need the password that encrypted the package to decrypt any sensitive data, without it the password to any sql connection as well as any other sensitive data is garbage....
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
May 5, 2016 at 9:46 pm
Ok nevermind. I found the cause... didn't know that the 266 get raised every time the tran count is different before and after executing an sp. That makes...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
February 22, 2016 at 11:36 am
amer-887457 (11/18/2015)
This is literally one of those 'sometimes it works, sometimes it does not'
I see the OLEDB getting one row as expected, firing just fine, but update does...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
November 18, 2015 at 2:08 pm
jbalbo (10/21/2015)
I am using the following "MySortedRows" routine
...
select count(icd10)as counticd10 ,icd10
,ROW_NUMBER() over (order by count(icd10) desc) as Row
,case when ROW_NUMBER() over (order by count(icd10) desc) > 5 then...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
October 22, 2015 at 8:34 am
There's isn't enough information on what you want to accomplish here. 30 of what query? What is the end result you're looking to get?
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
October 19, 2015 at 7:22 am
You can try setting the columns up as CHAR/NCHAR(x) instead of varchar or nvarchar... that should fix your width...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
October 6, 2015 at 10:52 am
I would check the ports to make sure it's not blocked. If I remember correctly in the configuration manager you can set the active ports for TCP/IP to be...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
October 6, 2015 at 10:07 am
Thanks Jeff... that helps me remember it if I understand why it's doing what it does.. 🙂
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
September 4, 2015 at 9:28 pm
Add this to the end?
,@x.value(
'(sql_variant1)[1]','FLOAT')
,@x.value(
'(sql_variant2)[1]','FLOAT')
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
September 4, 2015 at 2:22 pm
If I remember correctly with 2008 R2 you don't need separate msdtc... I'm 99% sure that you only need 1...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
September 4, 2015 at 2:04 pm
Luis Cazares (9/4/2015)
Be sure not to get lost on what this is doing. Since you're...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
September 4, 2015 at 2:00 pm
Something like this maybe...
Also check out Jeff Modden's article on cross tab/pivot... I think the part about aggregates is useful..
http://www.sqlservercentral.com/articles/T-SQL/63681/
declare @EmpID int = 1
declare @ChkDate date = '2015-6-15'
declare @test-2...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
September 4, 2015 at 11:43 am
SUBRAHMANYA HEDGE (9/4/2015)
We have a SQL 2008 Instance existing on active/passive cluster with 2 nodes running on Windows server 2008 R2 Ent. Edn.
Now we need to install another...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
September 4, 2015 at 11:14 am
SQLPain (9/4/2015)
The dilemma I am facing is that job is averaging 21 hours and it is scheduled for everyday, so the job pretty much keeps running all...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
September 4, 2015 at 10:54 am
Try something like this for the first step... not sure why it was put into a loop... unless I'm missing something...
declare @LoanID as table (LoanID varchar(10))
insert into @LoanID(LoanID)
select LoanID...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
September 3, 2015 at 4:05 pm
Viewing 15 posts - 1 through 15 (of 131 total)