Topics
Started by
Posts
Last post
Hi! Next, we need to unify SP 2 has a size pretty damn considerably. =) Let the following scenario:…
1 replies
In want to find which columns are updated in a row of a table, and what is their new value and prev…
5 replies
I created a query, that loops through the databases, but [database name].sys.database_principals se…
1 replies
Hi all I need some basic help in adding values to a column in a table(like making a key in EXCEL) a…
5 replies
Instead of placing the database into single user mode, while we load new data, I am trying to figur…
7 replies
Any help would be appreciated. I need to sum per product type and then I need to also sum dependin…
5 replies
Hello, I am trying to insert into a log table that stores the reason behind the non execution of a …
3 replies
Hey guys, I am querying a database to find out the dates of customers 1st, 2nd, 3rd, 4th purchases.…
4 replies
My table consists of 4 location IDs, each with a sensor reading value for each minute (approx) of t…
3 replies
Hi, Can we call stored Procedure inside a function Thanks
21 replies
Hi, can someone help me with PatIndex or CharIndex? I have a table below select 2011 as Year, 1111 …
1 replies
Hi using .sp_send_dbmail to email an xml file New at XML files, but my sample to recreate looks lik…
1 replies
Hi All, I need to get a minimum month and year from a table and then a row for every month/year up…
5 replies
How do you handle the “SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED” with common table expressi…
6 replies
I've taken a look at the scripts and forum posts on the site regarding finding duplicate rows, but …
4 replies
Viewing 15 topics - 3,526 through 3,540 (of 10,636 total)
You must be logged in to create new topics.