Topics
Started by
Posts
Last post
DECLARE @value1 int DECLARE @value2 smallint SET @value1 = 5 SET @value2 = 5 SET ROWCOUNT @value1 …
4 replies
All, I have one scenario. CREATE TABLE emp ( eno INT ) go CREATE TABLE emp_his ( eno INT ) go CREAT…
4 replies
Hi all, we have a scenario where we want to get the users who have the application roles, when I tr…
1 replies
I have a stored procedure that has the name of a SQL Server as one of its parameters. It uses this…
11 replies
Folks, I have three subqueries i made them as single and returned three columns as a|b|c now i n…
10 replies
Hello, how to change the code to make UNION between the results of the two exec's and the result to…
3 replies
I have a table that i need to replicate data in certain rows. example: ship code class targe…
3 replies
Hi, I have a table with starttime and endtime i need to select the first starttime and the last end…
3 replies
Hi All I need to calculate lgin hours of agents. The login and logout state code insert into table…
8 replies
I know it's possible to collect phone numbers in a comma separated string using XmlPath('') and Stu…
6 replies
[font="Courier New"]Hello SQL Gurus, I need some help here. I have part of the problem solved but …
2 replies
hi all am having a table like this . TABLE NAME - GROUP Name ------ xx yy aaa zzzz and i need to …
5 replies
I have a table that contains the origination structure e.g. - org, facility, department, unit. I n…
3 replies
Hi, When i execute the following Script. I get error 'Cannot roll back InnerTran. No transaction or…
3 replies
Hi everyone, I have a problem. I need to transpose some data and here is an example. IF NOT EXISTS…
1 replies
Viewing 15 topics - 2,401 through 2,415 (of 12,234 total)
You must be logged in to create new topics.