Topics
Started by
Posts
Last post
Hello, is there a way to query sys.databases or some other view or table for just user databases an…
8 replies
I am struggling to display the results recursively. My scenario is : Table Name: Organization Colum…
1 replies
Hello guys, I have a questions: I have a stored proc that delete lots of records by time in some ta…
7 replies
Hi All, I am facing some problem with a SQL join. I have three table with the following structure T…
6 replies
I need to parse a text variable via UDF for insert into a table variable used in a stored procedure…
6 replies
Hi, I have been puzzling over this for a whil now and I'm unable to fathom this out. I am trying to…
2 replies
Hi Guys, I am given a data file for data uploading process and one of the fields is a date. Occasio…
6 replies
Hi someone can tell me if is it possible to set a default value for a column, with the value of ano…
1 replies
Hi Folks I am trying to do a simple query and output to a csv file. SELECT * FROM mytable OUTPUT TO…
3 replies
There is a feedback entry for SQL 2008 at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=356…
1 replies
Hi Guys. I am not sure whether this question is ETL or StoreProcedure question... but since my bos…
2 replies
USE Northwind SELECT Title, Customerid FROM Employees CROSS JOIN Orders So, what I wanna do is to g…
43 replies
SELECT DISTINCT emp FROM #tblseat INDEX((IX_placing),NOLOCK) I get the this error when i exec abov…
2 replies
Hi all, Below statement works fine in 2000 what is equivalent in 2005? SET Grant = 'GRANT ALL PRIVI…
3 replies
Hi, If I have the following SQL (see below) why does it never hit the CATCH block? Obviously the e…
6 replies
Viewing 15 topics - 9,541 through 9,555 (of 12,230 total)
You must be logged in to create new topics.