Topics
Started by
Posts
Last post
I have a datetime column which has lots of these values: 2012-10-29 00:00:29.000 2011-10-15 00:00:2…
3 replies
I have a dataset with DateTime and Rowcount. I need to select rows only if 7 days or more have ela…
4 replies
Something like this select join_alias.col11, join_alias.col21 from (table1 a INNER JOIN table2 b ON…
4 replies
Hello, Here's my issue, I need to execute a procedure which needs a parameter, that parameter needs…
1 replies
given data like this: PatientID, StartDate, EndDate 1, 2012-10-15 10:00:00, 2012-10-17 08:59:00 Any…
9 replies
SELECT COUNT(tem.ComputerName) AS JavaRecords FROM (SELECT ComputerName FROM v_Java2345 UNION SELEC…
4 replies
Hi all, Looking at changing the recovery model of several DBs on a instance. Thought it would be a…
8 replies
Kerberos setup for SSAS 2008 R2?
5 replies
Hi all, where sql server indexed view data is stored. for example in oracle materialized vie…
2 replies
Hi, I'm using Sql Server 2008 and I was wondering if there was a clever way to work out which store…
2 replies
i have datawarehouse database where there is only primary key and no foreign keys. I have a conditi…
6 replies
Hi, I am confused about belwo statment. Although, Recovery model of TempDB can’t be changed…
5 replies
I'm trying to query some data with FOR XML to output the XML. Let's say I have data like this in m…
29 replies
Hello All, I have a bit of a 'is it possible without dynamic SQL' question. I have a table of Foote…
3 replies
Some body ask this question during interview. I didn't the answer i would like to know if someone g…
3 replies
Viewing 15 topics - 4,921 through 4,935 (of 10,647 total)
You must be logged in to create new topics.