Topics
Started by
Posts
Last post
I am writing a client-called stored procedure that is (intentionally) leaving a Transaction open in…
20 replies
Hi all, We are going to convert Oracle packages into MS SQL 2005. I would like to know, Is there to…
1 replies
Hello, I am trying to figure out how to reference multiple database/objects in stored procedures. I…
2 replies
I am looking for select statement against system tables/views to get following result set. Is it po…
2 replies
I need to identify inventory items that have not had a valid transaction within the last 12 months …
4 replies
isnull(A.Account_Established_Date, CONVERT(nvarchar(23), GETDATE(), 121)) is giving me: 2008-11-12…
5 replies
I am trying to create a SQL Script to pull data from three tables Accounts (list of Customers),Sale…
1 replies
Hello All, I have a requirement where I need to introduce duplicate records in the result set with …
2 replies
I have a table that after all is said and done, generates results like: [font="Courier New"] User …
10 replies
Hi , Is there a way to assign Server role to Login via CREATE LOGIN STATEMENT. Vishal 🙂
1 replies
Hi, I am working with sql-server 2005 since a few weeks, (before it was sql2000), and there is one …
3 replies
Hi! I was trying to created dynamic Tree view in asp.net 2.0 C# .Data Fetch from Database but it ex…
3 replies
is it possible to apply filter on result set produced by a system sp? For example i have used a sys…
4 replies
Hi all, Here's the thing. We have a system where products are sold by size and the data is kept ve…
15 replies
Hi All, The following query produces "91.00000000%" value select CAST(ROUND((((971 - 90)/(971 *…
2 replies
Viewing 15 topics - 8,341 through 8,355 (of 12,230 total)
You must be logged in to create new topics.