Topics
Started by
Posts
Last post
i have created a stored procedure which runs Perfect in SQL Server 2008 but producing error in SQL …
1 replies
Hi All, I am trying to understand how Rollup works. following query summarize Use AdventureWorks s…
2 replies
Hi All, Here is my question i would like to insert some values into two different table with s…
3 replies
I just ran accross a query that uses "=*" in a where clause. I know I read an article recently abo…
9 replies
I have: SELECT * FROM tablename WHERE AccountID = '000001' This returns a blank value as that Accou…
7 replies
In SSMS, I click a constraint and generate script create to, I got something like below: USE [Asset…
3 replies
I need help for following scenario. I have a table tb1 with following datetime columns. c1,c2,c3,c4…
11 replies
Dear Forum members, I am trying to capture the stats of dataware house. So I u…
7 replies
I have following table structure: CREATE TABLE [dbo].[Results]( [Id] [int] IDENTITY(1,1) NOT NULL…
9 replies
[font="Verdana"]Please if following queries, with their respective output, can be explained in simp…
5 replies
Hi all, I know that Try/Catch was supposed to make our lives easier, but I am still perplexed by th…
2 replies
Hi I am working on renaming some tables inside a database. For this I have made the following code:…
2 replies
Hi, I have a table as shown below with three columns EmpNo,ReferenceNo & Status. EmpNoReferen…
4 replies
Please consider this query for generating "Coin Tosses", heads or tails. It seems to contain some s…
18 replies
-- Count items per hour SELECT Year, Month, Day, Hour, /*COUNT(Hour) AS "Items per Hour",*/ COUNT(s…
3 replies
Viewing 15 topics - 8,161 through 8,175 (of 10,635 total)
You must be logged in to create new topics.