Topics
Started by
Posts
Last post
I have 2 insert into statements because the where clauses are different, is it possible to combine …
3 replies
Hi In following sql statement select * from tableA where year = '2009' and month = 'December' abov…
18 replies
I'm writing an app in VBA that connects to SQL2K5 database. The VBA app calls SQL procedures with p…
4 replies
There is one SP (SP_GenerateScript) available at the below URL: http://www.databasejournal.com/feat…
1 replies
Hello SQL-Gurus, I'm really happy to find this site as knowledge base. Now I'm facing another issue…
1 replies
oh man how do i describe this..... I created a cursor, the cursor checks for duplicate people based…
29 replies
One of the tables in our company was designed to be denormalized, the problem now is that I need to…
2 replies
I have a report which shows the working days of employees on month basis, from monday to friday. Us…
4 replies
Hi All, I hae a requirement to read xml text which i am inserting from my application to table , it…
9 replies
Is there an easy way to query which logins have execute permissions on various stored procedures? T…
1 replies
Tried the following to export some data to excel: INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',…
2 replies
What would be the SQL statement to select a project number base on the colors used in that project …
9 replies
Hi all, I need some help. I need to create a temporary table from 2 tables. ex : BEGIN TRAN set noc…
9 replies
I am executing an .exe file from a stored procedure. The exe is returning some values. How to store…
2 replies
Hi, we want to detect the valid date format such that the bolow case: 1.) '2009-01-32 00:00:00' or …
5 replies
Viewing 15 topics - 1,156 through 1,170 (of 17,082 total)
You must be logged in to create new topics.