Topics
Started by
Posts
Last post
This is a question asked in a test. There is a EmpWorkTime table having the columns and data as sho…
6 replies
Hi , I am trying to get the schedule for a resource. It may have multiple weekly schedules & o…
7 replies
Hi all experts, Is it possible in SQL Server to convert a string type to date like DECLARE @OrgDat…
2 replies
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
Viewing 15 topics - 3,526 through 3,540 (of 10,647 total)
You must be logged in to create new topics.