Programming SQL

Query
I am using this query to retrieve data. I want to select a record from this mentioned table Tb_Giveaway with respect to current date. I am not getting data while executing this qyery in sql server 2008. Can anybody help? select * from [Tb_Giveaway] where Dateforgiveaway=GETDATE() ... 2 Aug 2010 10:21

For XML Path / used with Pivot
I was able to use the below code example to get the results I was looking for. I put this together using different examples found googling for dynamic cross tab views. Can someone help me understand what is happening in The top part ... FOR XML PATH('') What does the last part... ), 1, 2, '') + ']' mea... 31 Jul 2010 10:43

Count over group
I have a view that I want to count the occurrance of a FedIDNo only once in a group of linked SSNs (using ROW_NUMBER() OVER ?). For instance, if I have the following I want to count only 1: FedIDNo SSN 123456789 987654321 123456789 998877654 Below is my SQL. SELECT dbo.ClientInfo.FedIDNo, d... 31 Jul 2010 17:17

Query total fish by angler by week
I was wondering if someone could give me a little help with a query. We have a fishing league that the anglers register the fish they caught each week online at a website I created. I am looking to create a query that will give me the total fish caught by an angler each week.We have 16 weeks in the league. There a... 3 Aug 2010 03:50

SSRS Report - when rows expanded they jump under fixed column head
I am having a problem with SSRS 2008 reports that have fixed column headers. Whenever a report has these fixed column headers and also has rows that get expanded, the row that gets expanded jumps underneath the header. The Row would be moving to the correct place if the header wasn't there but because the heade... 30 Jul 2010 10:47

fn_listextendedproperty
Tambi�n se resolvi� mi necesidad::: Muchas Gracias! (desde Lima, Per�) From http://www.developmentnow.com/g/113_2005_6_0_0_536945/fn-listextendedproperty.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/ ... 29 Jul 2010 16:19

Log Bad Records
I'm a relative newbie with SSIS in SS 2005. I have learned some of the basics about logging using SSIS, but I cannot figure out how to log a bad record. In other words, let's say I've got a text file with a 1,000 records and 2 of those records are bad and can't be loaded. I'd like for 998 to go into the table ... 29 Jul 2010 16:19

Simple Round call results in Arithmetic overflow
Hi, I'm a bit dazzled why this statement won't work in T-SQL : Select Round(9.990000, 0) The error I get is : Arithmetic overflow error converting expression to data type numeric. The result should be : 10 I've tried this in SQL 2005,2008 and 2008 R2 (Error message if from R2), didn't find anything in BOL... 29 Jul 2010 11:54

Attempt to fetch logical page in database
Hi, I am working on sql server 2008. I am getting a error that says: Attempt to fetch logical page(1:2986) in database 2 failed. It belongs to allocation unit 64.......not to 53........ If i run that SP in sql it shows no error and return the result set. But if i run that sp from vb.net code it give me above... 30 Jul 2010 05:21

Instead of UNION?
Rather than use a UNION statement to add the outputs of these two SELECT statements, is there another way to combine the outputs via one SELECT statement (I only want unique values of tblLSKTransactions.CounterID)? SELECT tblLSKTransactions.CounterID FROM tblLSKTransactions INNER JOIN tblLSKMembers ON tblLSK... 30 Jul 2010 19:40