Topics
Started by
Posts
Last post
I'm curious how to calculate the cardinality in this situation. SELECT * FROM Person p INNER JOIN P…
1 replies
Hi, below are the create table, the insert statement to insert some test records, and a query. CREA…
1 replies
I want to join two tables residing on different databases but on the same server but the authentica…
4 replies
Hi, Could anyone kindly help me with the following problem I am having (SQLServer 2008) I have a ta…
1 replies
I have a table with 2 columns First column has the reqid and second column has the Error Messages f…
2 replies
Ok, here's what I'm trying to do and I don't know if it can be done. Declare @Variable1 int = 0 Col…
16 replies
Hello, I have following query which is in SQL 200. I would like to use in SQL 2008. Though it will …
1 replies
Hi Guys, Plz see below table.. EmpID WrkdTime 12 2010-09-01 10:06:00.000 12 2010-0…
1 replies
Hi All, I have a table with approx 50,000 rows which stores files (.xls, .pdf, etc) as image dataty…
1 replies
I have a warehouse developed by some consultants. They have one large transaction table that they …
2 replies
Hello All, I'm running SQL 2008 R2 x64 (10.50.1600) I have crated the following User Defined Table …
16 replies
Hi, I tried for a query, for which I couldn't get the logic. Could you please guide me an approach …
14 replies
Hi, I hope someone can offer some advice.... I have the following query which works pretty well whe…
23 replies
Hi, Below SQL is taking around 3 minutes to fetch 87 thousand records. Is there any way I can optim…
1 replies
I have a report that will compare this years sales numbers year-to-date with last years numbers yea…
2 replies
Viewing 15 topics - 8,836 through 8,850 (of 10,647 total)
You must be logged in to create new topics.