Topics
Started by
Posts
Last post
I've created a trigger on a table. The trigger syntax appears to be correct but doesn't …
5 replies
I've created a user defined function that converts an IP address from a char into its decimal form.…
7 replies
Hi everyone. Can any one suggest how I could get this query to run under SQL server? SELECT …
2 replies
I have 5 subqueries that return a memo field in a select query. it looks like this select ptpg.note…
2 replies
Is there a method to cross join grouped queries and get the correct values? Here is what I'm doing.…
2 replies
I have 5 subqueries that return a memo field in a select query. it looks like this select ptpg.note…
1 replies
Hi all, I'm rewriting legacy code (DataFlex) as stored procedures for SQL Server. I just wrote the …
10 replies
I have a table which contains the fields: Plancode Startdate MemberNumber I need to have a query w…
2 replies
I've tried to have a stored procedure call a procedure on server two, and it just hangs up SQL. The…
3 replies
I have the following query; SELECT * FROM OPENQUERY(PROGEN, 'SELECT * FROM sysadm.creditors') This …
17 replies
I have had no previous experience with triggers, and am having trouble getting this to function. On…
7 replies
I've been trying to figure out how to parse account information stored in a table in XML format. I …
1 replies
Hi, I've seen this topic earlier here, but now I'm unable to find it. I'm required to fetch data fr…
5 replies
I am writing a script for one of my users to run. I want to setup a variable at the beginning to r…
17 replies
Can anyone recommend a really good book on T-SQL preferably with a DVD/CD
1 replies
Viewing 15 topics - 10,891 through 10,905 (of 17,082 total)
You must be logged in to create new topics.