Topics
Started by
Posts
Last post
Hi i want to create a table and load the result set from the following query and also it should ref…
4 replies
Hello all, I have a following situation: my table contains data of category assignments in certain …
6 replies
Hello, I am trying to pass a table name as a parameter in a Stored Proc. But it returns the followi…
1 replies
Hello, I have a Categories, Subcategories, and Company-Categories (CC) association table in my SQL …
1 replies
I ran a query which I want to roll back the actions of it. I did an update statement and failed to…
5 replies
I was asked to peek into a simple web project, which they were upgrading to avoid sql injection att…
4 replies
This seems doable but I can't get it to work. Would appreciate if someone could take a look... My t…
12 replies
ALTER PROCEDURE SP_TEST @P_TABLEN varchar(30), @P_STARTDATE datetime, @P_ENDDATE datetime, @COL…
10 replies
I have inherited an absolutely awful database with over 1,000 badly designed tables. I want to go …
6 replies
Hi, can anyone spot whats wrong with this simple SELECT IN I have a stored proc which has a paramet…
2 replies
I have a horse racing database and want to interrogate it to get a certain set of data out of it bu…
19 replies
...if any of you gurus way better at SQL than I am has a few minutes could you help me with this st…
3 replies
I am attempting to add a record to a table both via T-SQL or opening the table and adding the recor…
3 replies
When run script A there is 2 rows in resultset but although sp B run by using same paremeters and s…
2 replies
I have created a CTE, which works great, but now I have a problem with duplicates occurring. The sc…
4 replies
Viewing 15 topics - 8,221 through 8,235 (of 12,234 total)
You must be logged in to create new topics.