Topics
Started by
Posts
Last post
I have a result returned from a query that is the result of a join. I need to make the results rows…
46 replies
Unmask the data in XML Suppose there is a word 'Brilliant' in XML, look for 'Brilliant' in lookup t…
4 replies
DECLARE @p1 INT DECLARE @p2 INT SET @p1 = CAST((SELECT (col1 + col2) FROM #STOCK WHERE DAYSTOEXPIRY…
8 replies
I've tried a few variations of this, but the error is when I start my from statement: i.e. this is …
4 replies
Rather than posting all of my failed queries, I'll just show what I'm trying to do. auctions fields…
2 replies
Hello, While I would describe myself as "relatively competent" in TSQL to the casual observer, my s…
1 replies
I like sqlcmd. The postgresql command line sql utilities allow users to execute an sql statement o…
1 replies
Hi, I have a problem to find closest match data inputted with the one in Table. eg. In my Table, i …
11 replies
Hello Everyone, I have a table that contain (besides other columns) 2 fields Year (2014, 2015, etc.…
13 replies
Hello, I have multiple temp tables that return one row of results each. What would be the best wa…
6 replies
Hello everyone. I am new to T-SQL but I have been working on a project. I am attempting to use a mi…
15 replies
Hello, i would lite to transfer data from DB2 stored procedure to SQL server 2005 new table. I cre…
1 replies
I have a report where I need to get a random set <= 35 per group. I work in Sybase Rapid SQL so…
1 replies
hi fellow DBA's...just need your little help....this is my query in SQL Server 2000. "SELECT tblSch…
1 replies
How can I go about converting smalldatetime into int(4)?
10 replies
Viewing 15 topics - 136 through 150 (of 17,082 total)
You must be logged in to create new topics.