Topics
Started by
Posts
Last post
Following is my observation with 'WITH' I executed the below query SELECT * FROM Sales.SalesOrderDe…
2 replies
Hello Mate, I have the following TSQL but I meet a performance issue on Phase 3. Phase 1 and Phase …
24 replies
Per msdn, there is a permissions restrictions where,,, Permissions --------------------------------…
18 replies
Hello All, how to show results in pivot format, please assit me to get the desired output as attach…
4 replies
Hi, I have a data structure as followed : [Name], [Task] and the data is : John, task1 John, task2 …
12 replies
I have a cte script to create a calendar table for 53 weeks, starts at 2011-01-01 (week 1, Saturday…
2 replies
Does a database diagram exist of SQL Server's system tables? I am looking for documentation that …
5 replies
Hi all, I have a problem with my "union" query, this a sample of my query. What I'd like to obtain …
4 replies
I suspect the answer is going to be "No" but thought I'd check with more experienced heads than my …
14 replies
I have a scenario whereby I need to aggregate n number of discounts to get a total discount %. Eac…
7 replies
Hello, Need help with in writing a Stored Procedure for Auto Alpha Numeric Generation. If I pass…
16 replies
I have data with attendance hours/dates for every day of the month/year. I need to create a query w…
6 replies
I'm working on the database from hell, so bear with me... (they think 'normalization' is a dirty wo…
14 replies
Hi Every Body, i am strucked up in creating stored procedure.... My scenario is: I Have a table S…
4 replies
Hello All I have below 3 sql queries which gives results on order by accounts, Now the question is…
3 replies
Viewing 15 topics - 3,961 through 3,975 (of 10,636 total)
You must be logged in to create new topics.