Viewing 15 posts - 2,656 through 2,670 (of 3,489 total)
not near enough information to help. How old is your latest backup? Do you have your transaction logs somewhere? what recovery model are you using?
February 21, 2015 at 1:57 pm
Easiest way is to use a Calendar table and do the math in a stored procedure. Then base the report on that.
February 20, 2015 at 3:49 pm
You tried grouping? Keep at it... that was the right direction.
SELECT ID
, MAX(Lang1) AS Language1
,MAX(Lang2) AS Language2
,Max(Lang3) As language3
,MAX(Lang4) AS Language4
FROM
(SELECT 1001 AS ID, Null as Lang1,'Japanese' as Lang2,Null As...
February 19, 2015 at 11:25 pm
Cool! Thanks for the report.
February 19, 2015 at 3:51 pm
What I found is that multi-valued parameters just plain don't work the way I expected them to. They work fine if you're stuffing them in an IN() clause in...
February 19, 2015 at 1:52 am
Looks like the simple answer to this is to use 3 separate Boolean parameters instead of one Multi-valued integer.
Just to test my theory, I tried creating a multi-valued parameter and...
February 18, 2015 at 7:48 pm
since your result looks like a matrix, I just have to ask - what does your underlying dataset look like? (or the table in question).
If your data table isn't normalized...
February 17, 2015 at 1:48 pm
Come to think of it, you might want to look up Doug Steele's DSNless connection code for Access. (Not entirely sure it works for SQL Server, but I don't see...
February 16, 2015 at 3:21 pm
You should be able to relink the tables to SQL Server.
If you use integrated security in SQL Server (so Active Directory handles authentication), you would just have to create groups...
February 16, 2015 at 2:42 pm
now I want to call all the sp on the basis of input like If filename is Fdoor then it shold fire the SP_Archive_using_merge_Fdoor , if file name is Fdoop...
February 15, 2015 at 11:37 pm
February 13, 2015 at 11:17 pm
use a calendar table, omit all the days that fall on Sat/Sun and Holidays. Sort in descending order and return the TOP value?
February 12, 2015 at 11:58 pm
Here's Jeff Moden's DelimitedSplit8K function for doing that.
February 12, 2015 at 11:08 pm
Oh, I thought that's what Jeff's code did. Guess I have more to learn than I thought!
February 11, 2015 at 9:20 pm
February 11, 2015 at 5:27 pm
Viewing 15 posts - 2,656 through 2,670 (of 3,489 total)