Topics
Started by
Posts
Last post
osql -S"servername" -Uusername-Ppassword -dmsdb -ijob_stop.sql -olog.txt type log.txt>>finall…
2 replies
Hello folks, I'd be grateful if people could cast their eye over my Select statement. Is this the r…
3 replies
While executing the following commands -- Set 1 alter table employee add test varchar(10) update em…
1 replies
By: Sergiy
Hi Guys I am Working on Adventureworks2008 and i have a question about how can i get the employment…
2 replies
DECLARE @SelectQueryNVARCHAR(MAX) DECLARE @WhereQueryNVARCHAR(MAX) SET @WhereQuery = ' WHERE CON…
6 replies
By: Sergiy
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql90/html/SQLruleengine.asp I fou…
1 replies
Hi all, I have a process, which needs to take in multiple files from a source folder, then update a…
4 replies
I'm stuck here. I've been trying to find a way to select the latest FinancialYear record for each m…
4 replies
Hi all, Here is the case. I want to create a kind of an view where I present data from a table. ta…
3 replies
I have a table that has about 60 columns and carries 40 million records. I have to create a report …
5 replies
By: Sergiy
I followed one of the examples in sqlservercentral to create a trigger that stores data in an audit…
5 replies
my statement as follow, declare @yyyymm as varchar(6) set @yyyymm='200910' i want my resultset as f…
6 replies
Hi Guys Can You guys help me to understand Group By Query By Using The function. I am unable to un…
1 replies
hi, I want to query a table with columns : ID , field1, field2 and use group by statement to group …
5 replies
My table and data as follow, declare @tTrip TABLE ( TID int not null primary key, DrID1 varchar (20…
3 replies
Viewing 15 topics - 1,246 through 1,260 (of 17,082 total)
You must be logged in to create new topics.